Vlookup on blank cells formatted with dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=IF(ISNA(VLOOKUP(A1,'[Workbook]Tab2'!$A:$Z,2,FALSE)), "",
VLOOKUP(A1,'[Workbook]Tab2'!$A:$Z,2,FALSE)))

is this what you require?
 
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 said:
=IF(ISNA(VLOOKUP(A1,'[Workbook]Tab2'!$A:$Z,2,FALSE)), "",
VLOOKUP(A1,'[Workbook]Tab2'!$A:$Z,2,FALSE)))

is this what you require?


Ayse said:
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
Click to expand...
Click to expand...
 
=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 said:
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 said:
=IF(ISNA(VLOOKUP(A1,'[Workbook]Tab2'!$A:$Z,2,FALSE)), "",
VLOOKUP(A1,'[Workbook]Tab2'!$A:$Z,2,FALSE)))

is this what you require?


Ayse said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top