Apr 11 2022 08:43 AM
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,"")
Apr 11 2022 08:49 AM
@BDawgTheHusky Could it be that the formula returns the value from Shipping!H11 which perhaps is empty?
Apr 11 2022 09:21 AM
Apr 12 2022 04:17 AM