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