=IF(Input_Sheet!D52="","",Input_Sheet!D52)


J

Jim

Hello,

I would like to ask for help with this formula. It works great, however I
have a vlookup making reference to the cell where I have this forula
(=IF(Input_Sheet!D52="","",Input_Sheet!D52)). The vlookup is making a
return. How do I change this formula
(=IF(Input_Sheet!D52="","",Input_Sheet!D52)) to give the appearance of a
blank so the vlookup returns a blank cell.

Here is the vlookup I'm using:
=IF(ISERROR(VLOOKUP(I44,[Master_Data_Sheet.xls]Master_Sales_Lookup!$A$10:$AA$88,4,FALSE)),
"",
VLOOKUP(I44,[Master_Data_Sheet.xls]Master_Sales_Lookup!$A$10:$AA$88,4,FALSE))

Thanks for the help.
Jim
 
Ad

Advertisements

J

Jim Thomlinson

A couple of things. With your Vlookup you should probably be using ISNA
instead of ISERROR. With IsError if the source file is moved or deleted then
the formula will return blank when in reality it should be an error as it did
not try to look up anything.

To that end try this...
=if(or(isna(vlookup(...), vlookup(...) = ""), "", vlookup(...))
 
Ad

Advertisements

J

Jim

Jim,

I changed the ISERROR to a ISNA. However I am still receving data in the
other field where the (=IF(Input_Sheet!D52="","",Input_Sheet!D52)) is
presented. Do you have any thought about how I can blank this cell?



Jim Thomlinson said:
A couple of things. With your Vlookup you should probably be using ISNA
instead of ISERROR. With IsError if the source file is moved or deleted then
the formula will return blank when in reality it should be an error as it did
not try to look up anything.

To that end try this...
=if(or(isna(vlookup(...), vlookup(...) = ""), "", vlookup(...))
--
HTH...

Jim Thomlinson


Jim said:
Hello,

I would like to ask for help with this formula. It works great, however I
have a vlookup making reference to the cell where I have this forula
(=IF(Input_Sheet!D52="","",Input_Sheet!D52)). The vlookup is making a
return. How do I change this formula
(=IF(Input_Sheet!D52="","",Input_Sheet!D52)) to give the appearance of a
blank so the vlookup returns a blank cell.

Here is the vlookup I'm using:
=IF(ISERROR(VLOOKUP(I44,[Master_Data_Sheet.xls]Master_Sales_Lookup!$A$10:$AA$88,4,FALSE)),
"",
VLOOKUP(I44,[Master_Data_Sheet.xls]Master_Sales_Lookup!$A$10:$AA$88,4,FALSE))

Thanks for the help.
Jim
 

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

Top