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
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
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
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 207 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!