Index/Match wrong result

**spinkung** · 04-14-2015, 03:36 AM

Hi

i am having some trouble with the index/match lookup.

I have a sheet with a linked table (to sql) with product info. i am trying to return the product description from that table to another sheet using product code.

so...
=INDEX(MyTable[Description],MATCH($F2,MyTable[ProductCode]))

however, the result for code YWX0001 should return the description WATER. what i'm actually getting is the description of the last row in the table.

i've also tried not referencing the table which also doesn't work

so...
=INDEX(MySheet!B:B,MATCH($F2,MySheet!A:A))

weird!

**TMS** · 04-14-2015, 03:43 AM

Try:

Formula:

Please Login or Register  to view this content.

Regards, TMS

**TMS** · 04-14-2015, 05:20 AM

Given this thread is marked solved, I take it that was the solution you were looking for?

It is common courtesy in most forums to acknowledge the contribution and confirm that it worked for you.