Tried this one it says UNPARSEABLE??

edited 09/17/21

=INDEX({Description List}, MATCH([Description]@row,{TGS Part Number},0))

Tags:

• ✭✭✭

Hope you're having a great day!

Do you want the formula to return the description or a part number? The above tells me that you are matching a description in some range, collecting that row number, and then displaying the description in that row.

If you could provide some screenshots that would help us get you to the proper solution!

Best,

Lidiya Shutaya

lidiya@ddbconsultants.ca

• edited 09/20/21

Hi Lidiya,

I need help to return the Source Sheet Column (Category Code (TGS Part Number) in the column to the left of the Destination sheet (Description) column.

The screenshots are below. First is the destination sheet second is the source sheet

• ✭✭✭✭✭✭

I hope you're well and safe!

Try something like this.

```=INDEX({TGS Part Number},MATCH(Description@row,{Description List},0))
```

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

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

Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. 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:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

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

• Thanks, works fine

• ✭✭✭✭✭✭

Excellent!

You're more than welcome!

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

```=INDEX({ColumnWithTheValueYouWantToShow}, MATCH(CellThatHaveTheValueToMatch@row,
{ColumnWithTheValueToMatchAgainsTheCell}, 0))
```

Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. 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:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

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

• edited 09/20/21

Please help with the below I`ve done the same but need to return the Unit price value. Linked to Part Number Value. Says the same error as before. I tried to copy what you said above but still no luck.

=INDEX({Unit Price}, MATCH(TGS Part Number@row,{TGS Part Number}, 0))

• ✭✭✭✭✭✭

Try something like this.

```=INDEX({Unit Price}, MATCH([TGS Part Number]@row,{TGS Part Number}, 0))
```

Did that work?

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

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

• Yes thanks that`s excellent work

• ✭✭✭✭✭✭

Excellent! Thanks!

Happy to help!

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!