ABCDEF
1
2
LIST TO LOOK UPRESULT OF LOOKUP
3
ID123,ID456,ID567Tony Schmidt, Leroy Kuhn, Connie Wright
4
5
TABLE OF VALUESTOTAL FORMULA
6
IDVALUE
=join(", ",transpose(query(Sheet2!A:B,"Select B where A matches '"&join("|",split(A2,","))&"'",0)))
7
ID123Tony Schmidt
8
ID456Leroy Kuhn
9
ID567Connie Wright
10
11
12