Tried this one it says UNPARSEABLE??

Eric Goldsmith

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

Andrée Starå

@Eric Goldsmith

Try something like this.

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

Did that work?

Lidiya S.

@Eric Goldsmith

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

Eric Goldsmith

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

StockItemsImage1.JPG

StockItemsImage2.JPG

Many Thanks in advance

Andrée Starå

Hi @Eric Goldsmith

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!

Eric Goldsmith

Thanks, works fine

Andrée Starå

@Eric Goldsmith

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!

Eric Goldsmith

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.

Please help

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

Andrée Starå

@Eric Goldsmith

Try something like this.

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

Did that work?

Eric Goldsmith

Yes thanks that`s excellent work

Andrée Starå

@Eric Goldsmith

Excellent! Thanks!

Happy to help!