However, I need to give you a clear and important answer:
=INDEX(B2:B10, MATCH("Apple", A2:A10, 0)) Works for vertical lookups, but the lookup column must be the first column. xlookup add in download for excel 2010 free download
=INDEX(return_range, MATCH(lookup_value, lookup_range, 0)) Find the price of "Apple" in a table. However, I need to give you a clear
I understand you’re looking for an for Excel 2010 that is free . 0)) Works for vertical lookups