Did you delete the row and get #N/A?
What does the 'bad row' have?
If you replace the =row() with Y or N you should get that, right?

Do you get Y or N by a formula?

Can you share the file? Either email to me or upload at a site like
wikesend.com and paste the link here..

"PAL" wrote:

I did repllace the source field w/ =row() and it gave the correct row number.

"Sheeloo" wrote:

I am assuming ABC is a named range ...
If =VLOOKUP(A2,ABC,21,FALSE) is returning a 0 it means the 21st column in
ABC for the value of A2 is blank... this means that
Vlookup must be getting a match in an earlier row than the row you think it
is matching...
The most compelling clue is that you are still getting 0 if you delete that
row... you would get a #N/A if that was the row VLOOKUP was returning the
value from.

To test replace the values in your 21st columns by the formula
=row()
this will tell you which row it is returning from... Also it will tell you
that VLOOKUP is working fine...
-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"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.