Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP ?
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |