=INDEX(B2:B10, MATCH("Apple", A2:A10, 0)) Works for vertical lookups, but the lookup column must be the first column.
However, I need to give you a clear and important answer: 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. 0)) Works for vertical lookups
Your subscription to The Christian Science Monitor has expired. You can renew your subscription or continue to use the site without a subscription.
If you have questions about your account, please contact customer service or call us at .
This message will appear once per week unless you renew or log out.
Your session to The Christian Science Monitor has expired. We logged you out.
If you have questions about your account, please contact customer service or call us at .
You don’t have a Christian Science Monitor subscription yet.
If you have questions about your account, please contact customer service or call us at .
