Vlookup on blank cells formatted with dates

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
 
G

Guest

=IF(ISNA(VLOOKUP(A1,'[Workbook]Tab2'!$A:$Z,2,FALSE)), "",
VLOOKUP(A1,'[Workbook]Tab2'!$A:$Z,2,FALSE)))

is this what you require?
 
G

Guest

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...
 
G

Guest

=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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP Returns a zero value 2
VLookup and #N/A 6
VLOOKUP returning a value when it shouldn't 2
=IF(ISERROR(VLOOKUP(A3,contacts!B:I,5,FALSE)), " ", VLOOKUP(A3,con 4
vlookup cell reference 2
how to return an address from a lookup into a table? 7
Formatting 0 values to show blank cells 4
Blank dates showing as 00 january 1900 - help 3

Top