| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup on blank cells formatted with dates
=IF(ISNA(VLOOKUP(A1,'[Workbook]Tab2'!$A:$Z,2,FALSE)), "",
VLOOKUP(A1,'[Workbook]Tab2'!$A:$Z,2,FALSE))) is this what you require? "Ayse" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup on blank cells formatted with dates
Thanks for your reply.
My formula is correct. I think I need to add to it and not remove. What I am doing with my formula is to look for a value (A1) in one sheet and if it is not there to look at another sheet and return the applicable value (2). My question is if my applicable cell value is blank and is formatted with date, how do I make it return "" instead of 0 or #N/A. Thanks in advance "Toppers" wrote: =IF(ISNA(VLOOKUP(A1,'[Workbook]Tab2'!$A:$Z,2,FALSE)), "", VLOOKUP(A1,'[Workbook]Tab2'!$A:$Z,2,FALSE))) is this what you require? "Ayse" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup on blank cells formatted with dates
=IF(ISNA(VLOOKUP(A1,'[Workbook]Tab2'!$A:$Z,2,FALSE)),
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)) "Ayse" wrote: Thanks for your reply. My formula is correct. I think I need to add to it and not remove. What I am doing with my formula is to look for a value (A1) in one sheet and if it is not there to look at another sheet and return the applicable value (2). My question is if my applicable cell value is blank and is formatted with date, how do I make it return "" instead of 0 or #N/A. Thanks in advance "Toppers" wrote: =IF(ISNA(VLOOKUP(A1,'[Workbook]Tab2'!$A:$Z,2,FALSE)), "", VLOOKUP(A1,'[Workbook]Tab2'!$A:$Z,2,FALSE))) is this what you require? "Ayse" wrote: 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 |
| Reply |
| 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 | |||
Linear Mode
