| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup on blank cells formatted with dates
I am trying to do a IF(ISNA(Vlookup)) function to return dates. The problem
is my function returns a weird date when my lookup value is blank, when I change the format of the cell from date to general, text, etc, this time it returns 0. I want my function to return blank when the cell I am trying to look up is blank. Does anyone know how to do this? My function is as follows: =IF(ISNA(VLOOKUP(A1,'[Workbook]Tab2'!$A:$Z,2,FALSE)), VLOOKUP(A1, '[Workbook]Tab1'!$A:$Z,2,FALSE), VLOOKUP(A1,'[Workbook]Tab2'!$A:$Z,2,FALSE)) second row (2) above is the cell with the date Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If a range of cells in Excel are formatted as dates ie. (mm/dd/yy) | Excel Discussion (Misc queries) | |||
| Need Vlookup to return a value of $0.00 in blank cells | Excel Worksheet Functions | |||
| countif non blank cells + dates overdue | Excel Worksheet Functions | |||
| I want blank cells, but they're all zeros now that I have formatted them | Excel Discussion (Misc queries) | |||
| Converting 'General' formatted cells to Text formatted cell using. | Excel Worksheet Functions | |||
Threaded Mode
