This formula is working fine, except that my data is imported from MS Access
and Excel seems not to recognize the correct data type.
I have two data sets imported from two different Access queries on the same
worksheet. I'm using my first data set/range as the base, then I have added 4
new columns that I need to populate with "Y"/"N" by looking up 2 to 3 vlaues
on my base to match them with values on the 2nd data range. So far my formula
give the correct results for some rows while giving incorrect results for
others. I have foreced the data type to match on both ranges. I also cleared
both ranges, applied my desired data type before importing the data, but
still that didn't help. I also tried to use the "--" (I use it sometimes in
SUMPRODUCT), it will change the incorrect results to the correct ones, but it
will do the same to the correct ones (change them to show incorrect results).
If I type the values over in one row I will get the correct results, but
obviously that not an option for thousands of records, and having to do that
every time we refresh the data. Is there a better way to force the formula to
ignore any data mismatch? All of my data in both ranges are either 'general'
or 'text'.

Thanks.

=IF(AND(ISNUMBER(MATCH(Z13,AC2:AC4500,0)),ISNUMBER (MATCH(AA13,AF2:AF4500,0)),ISNUMBER(MATCH(AB13,AG2 :AG4500,0))),"Y","N")

--