RDEXCEL2020
Member
Hi
I have this code works perfectly. The cell where I have the formula it appear "0". I want it to show blank if there is no entry in D1:D40.
Thanks.
=IFERROR(LOOKUP(2,1/(testing=$B1),Sheet2!$D$1:$D$40),"")
I have this code works perfectly. The cell where I have the formula it appear "0". I want it to show blank if there is no entry in D1:D40.
Thanks.
=IFERROR(LOOKUP(2,1/(testing=$B1),Sheet2!$D$1:$D$40),"")