VLOOKUP ?
The problem might lie with the expression of
IF(VLOOKUP($A2,ABC,54,FALSE)="","",VLOOKUP($A2,ABC ,54,FALSE)). The way the
formula is written in redundant. If the result of the formula is "", then
you don't need to say -then give me ""-. The VLOOKUP($A2,ABC,54,FALSE) is
sufficient. It is like saying if the answer is A, then give me A otherwise
give me the answer, which is A. Are you looking for an error?
Next, can you tell what the value is supposed to be when it returns a zero?
Make sure that the lookup value on your source data sheet is not zero.
--
Regards,
PJ
Please rate this post using the vote buttons if it 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.
|