INDEX / MATCH Function Combination in Google Sheets

Find out how to use the INDEX and Match function combination in Google Sheets - a better alternative to lookups.

If you would like to learn more about Google Sheets check out our full-length tutorials:

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

⚖ DISCLAIMER
Information provided in our videos does not constitute financial, taxation, legal, business or other professional advice. If you make a purchase through an affiliate link provided here we may receive a commssion. We do not accept any responsibility or liability for purchases made through third-party vendors, websites, or services. It is your reponsibility to review and understand the terms, conditions, and policies of third parties before making any purchases.

[nachozz]

I've been looking for this for HOURS! thank you very much!

[DiaborMagics]

I have an "issue", or more, something that I find rather odd. In the INDEX, if I do not add the header row to the range, the result at the end will actually be 1 cell below the one I actually need, so if for example I were to look up the "Anna" equivalent in my own sheet, then it finds Paul's row/information instead, the one right below it. It will only find the correct value if I include the header row into the range I feed to the beginning of the INDEX formula.

[ksypula]

Hi, really great presentation - simply and specific :)

I have a question. There were two "Anna" in the column. How I can get all "Anna" and the "State" for them?
Is it possible with using INDEX / MATCH?