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)))
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: