Hi

Your formula doesn't look right, in your formula,
I don't see the table array or range and the reference to another
is incorrect if you are placing the formula in another sheet.

Something like this
=VLOOKUP(A2,ABC!$A$2:$B$100,2,FALSE)

This won't return a Y or N, it will return the lookup value if there
matching data

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"PAL" wrote:

I am working with a file w/ multiple sheets. The raw data is on a sheet
called ABC which is copied from another file.

One of my analysis sheets has 132 rows.

This formula will return a Y or N: =VLOOKUP(A2,ABC,21,FALSE)

This formula will return a date if it is not blank:
=IF(VLOOKUP($A2,ABC,54,FALSE)="","",VLOOKUP($A2,AB C,54,FALSE))

I copy this formula down to the last row. It seems the data won't appear for
a single row in the middle of the table. 131 rows are correct. For the bad
row, I get a zero instead of Y or N and blanks for the dates.

I have checked to ensure the format is right, General for the first, and a
date format for the second. I have also deleted the row and tried again. I
really prefer to get it autopopulated then manually put in the data.

Help.