Match and lookup or better

Originally Posted by The_Snook

Hi rogrand,

Pop this in cell A2 and copy it down. I've wrapped the IFERROR function around it as not all of the COID numbers have a corresponding match.

=IFERROR(INDEX(Table2[Market],MATCH(Table1[@COID],Table2[COID],0)),"")

Regards,

Snook

It fill in a market, but it takes the first cell and its not looking up and matching.