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

  • Thread starter Thread starter Jim
  • Start date Start date
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
 
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,

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