Google-sheets – Create case sensitive vlookup with array based search key

google sheets

I have the following case sensitive vlookup formula however search_key must be a single value here, and I need to search an array of keys.

=ArrayFormula(INDEX(return_array, MATCH (TRUE, EXACT(search_array, search_key), 0)))

Best Answer

try something like:

=ARRAYFORMULA(IFERROR(VLOOKUP(EXACT(A1:A); EXACT(Sheet1!A1:B); 2; 0)))