Forum Discussion
Solved
Looking up multiple different values with VLOOKUP?
Hi, I am currently working on an Excel file which should automatically place email addresses in a column based on names in a different column. Similar to this: To achieve this, the c...
Let's say the sheet that lists the email addresses is named List.
In C2:
In Dutch:
=TEKST.COMBINEREN(";"; WAAR; X.ZOEKEN(TEKST.SPLITSEN(B2; ", "); List!A:A; List!B:B; ""))
In English:
=TEXTJOIN(";", TRUE, XLOOKUP(TEXTSPLIT(B2, ", "), List!A:A, List!B:B, ""))
Let's say the sheet that lists the email addresses is named List.
In C2:
In Dutch:
=TEKST.COMBINEREN(";"; WAAR; X.ZOEKEN(TEKST.SPLITSEN(B2; ", "); List!A:A; List!B:B; ""))
In English:
=TEXTJOIN(";", TRUE, XLOOKUP(TEXTSPLIT(B2, ", "), List!A:A, List!B:B, ""))
Yesss that works, thank you so much Hans! Way easier than expected 😄