Complicated Index Match Formula
Hopefully someone can help me out with the below scenario:
I need to pull Company Name from another sheet that matches the Name (ie AAA). Then I need to pull the ranking which is a different column in the same sheet that matches both Name and Company Name.
Best Answer
-
Hi @Nana250
You would use two separate INDEX(MATCH formulas, one for each column to return.
Here's a Help Article that goes through how to set up an INDEX(MATCH:
So in your case, something like this for the Company Name column:
=INDEX({Company Name}, MATCH(Name@row, {Name Column}, 0))
Then delete out the first reference and replace it with the Ranking column reference for your second formula:
=INDEX({Ranking Name}, MATCH(Name@row, {Name Column}, 0))
See: Create cross sheet references to work with data in another sheet
Cheers,
Genevieve
Answers
-
Hi @Nana250
You would use two separate INDEX(MATCH formulas, one for each column to return.
Here's a Help Article that goes through how to set up an INDEX(MATCH:
So in your case, something like this for the Company Name column:
=INDEX({Company Name}, MATCH(Name@row, {Name Column}, 0))
Then delete out the first reference and replace it with the Ranking column reference for your second formula:
=INDEX({Ranking Name}, MATCH(Name@row, {Name Column}, 0))
See: Create cross sheet references to work with data in another sheet
Cheers,
Genevieve
Help Article Resources
Categories
Check out the Formula Handbook template!