Forum Discussion

BDawgTheHusky's avatar
BDawgTheHusky
Copper Contributor
Apr 11, 2022

Using VLookup and showing 0 instead of being left blank

Hello,

I am using VLookup between sheets. I want it to look at the data from the first sheet, and if the data in one column is the same as todays date, it will copy the information from the first sheet into my new sheet. The error I am having, is that if the cell in the first sheet is blank, I am wanting it to be blank when it is copied to the second sheet, but instead it is showing 0. Is there a way I could modify my formula to keep the resulting cell blank?

 

=IF(Shipping!J11=TODAY(),Shipping!H11,"")

excel
Formulas and Functions

3 Replies

  • Patrick2788's avatar
    Patrick2788
    Silver Contributor
    Apr 11, 2022
    Try this:
    =LET(i,IF(Shipping!J11=TODAY(),Shipping!H11,""),IF(i=0,"",i))
    • BDawgTheHusky's avatar
      BDawgTheHusky
      Copper Contributor
      Apr 12, 2022
      Hello, the value from Shipping!H11 is empty but that is intended. I am wanting the code to see the empty cell in Shipping!H11 and output another empty cell, rather than output a 0.

Resources