Complicated Index Match Formula

Nana250

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.

Genevieve P.

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:

https://help.smartsheet.com/articles/2482647-cross-sheet-formula-combinations

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

Genevieve P.

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:

https://help.smartsheet.com/articles/2482647-cross-sheet-formula-combinations

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