Forum Discussion
BDawgTheHusky
Apr 11, 2022Copper Contributor
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 sh...
Riny_van_Eekelen
Apr 11, 2022Platinum Contributor
BDawgTheHusky Could it be that the formula returns the value from Shipping!H11 which perhaps is empty?
BDawgTheHusky
Apr 12, 2022Copper Contributor
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.