Formula INDEX/MATCH is pulling wrong values. Does anyone have similar experience?

pavla70006

Formula used:

Sheet it's pulling from:

Result: NO MATCH although the code exists exactly the same in both sheets.

Sam M.

Hi pavla70006,

Sometimes with MATCH you can put a 0 at the end and it helps find a definitive match to what you are looking for:

=INDEX({Expected Date},MATCH([Course Code]@row,{eDL Code},0))

 

I did some testing.

Without the 0 I had the same error:

With the 0:

Sheet it’s pulling from:

Hope it helps,

Sam