# Index and Match formula

✭✭✭✭✭

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.

• ✭✭✭✭✭✭

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!

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭

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?

• ✭✭✭✭✭✭

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.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!