Match using mixed numeric & alphanumeric list

[boot]

Hi,
I am having trouble using the MATCH function. The list that is being searched contains both numeric and alphanumeric entries, but only the alphanumeric entries give the correct result. It's almost as though it can't see the numeric entries. I have sorted the list into ascending order.
My formula is below...

[ =IF(ISNA(MATCH(D2,'day'!B2:B152,0)),"NO","YES") ]


I know this is normally something really simple but it's starting to drive me mad.
Any help would be much appreciated.

 

[BrianB]

A quick test shows no problem with this in my setup. XL97/NT4 (Cell format "General")

Similar problems with VLOOKUP() are solved by ensuring that columns are formatted as text - then selecting the columns in turn and using Data/Text to Columns/finish to force the re-format.

 

[boot]

Thanks Brian. I had already tried changing the formats but didn't think about using Data/Text to Columns etc. It worked a treat!

The headache is receeding now!

Thanks again