Index and Match formula

Melissa Torrez

I am trying to write an Index, Match formula and I am having trouble

=INDEX(MATCH([Row ID]@row, {Value Prop range}, 0), 1)

For example, I am referencing another sheet where if Row ID 55 has a value proposition of 'time savings' in the value proposition column then I want to match the value in the 'Time Savings column' and so on and so forth.

Andrée Starå

Hi @Melissa Torrez

Here's the structure of an INDEX/MATCH formula.

=INDEX({ColumnWithTheValueYouWantToShow}; MATCH(CellThatHaveTheValueToMatch@row; 

{ColumnWithTheValueToMatchAgainsTheCell}; 0))

Did that help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Melissa Torrez

Hi @Andrée Starå

Thanks for your help, however I am still not getting the result I am looking for. Maybe index match is not the correct formula for what I am trying to do.

I am trying to return a description from another range of columns depending on the value proposition selected. So, if the value proposition is time savings in the value proposition column for the Row ID I want to lookup, then I want to return the text in another column which in this example would be the text in the time savings column. Would a Vlookup be better?

Sameer Karkhanis

You are basically missing the "Range" argument in the INDEX function. Should be,

Step 1: Below will give you what the value proposition value is for the row id matched

=INDEX({Value Proposition in Sheet A}, MATCH([Row ID]@row, {Row ID in Sheet A},0))

You will then need to nest the above in the formula to match and get the value from the Time Savings column for the corresponding row.