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...
Patrick2788
Apr 11, 2022Silver Contributor
Try this:
=LET(i,IF(Shipping!J11=TODAY(),Shipping!H11,""),IF(i=0,"",i))
=LET(i,IF(Shipping!J11=TODAY(),Shipping!H11,""),IF(i=0,"",i))