| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
1 | ||||||
2 | LIST TO LOOK UP | RESULT OF LOOKUP | ||||
3 | ID123,ID456,ID567 | #VALUE! | ||||
4 | ||||||
5 | TABLE OF VALUES | TOTAL FORMULA | ||||
6 | ID | VALUE | =join(", ",transpose(query(Sheet2!A:B,"Select B where A matches '"&join("|",split(A2,","))&"'",0))) | |||
7 | ID123 | Tony Schmidt | ||||
8 | ID456 | Leroy Kuhn | ||||
9 | ID567 | Connie Wright | ||||
10 | ||||||
11 | ||||||
12 | ||||||