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

[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

 

[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(...))

 

[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?

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

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