Index formula returning inconsistent results

[Phlugg]

Hi Guys, I'm using this formula;
=IF(INDEX(B:B,MATCH(B:B,Master!B:B,0),0)=B13,"Yes","no") to look at values in one column and check to see if the same value is on another column.

For two adjacent cells in the same column, it is telling me that the data does exist in the reference column for one, but not for the next - even though i can clearly see that it does. I can see no formatting or other obvious reason for why it is working as expected for one value - but not for the next. Any ideas?

Nick

 

[Jerry Sullivan]

Hi Nick,

You show B:B as the Lookup parameter of the MATCH function. Is that intentional or should that be a single cell or value?
MATCH(B:B,Master!B:B,0)

 

[Robert Mika]

Have you excluded any preceding or following spaces.
They are sometimes hard to spot.

 

[Aladin Akyurek]

Does...

=IF(ISNUMBER(MATCH(B13,Master!B:B,0)),"Yes","no")

give you what you are after?