• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VALUE IN CELL

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),"")
 
Here is the sample document.
I need to have the cell to show blank if there is not entry in Sheet2 D1:D40
Example if you select Peach the it should show blank and not "0".

Thanks
 

Attachments

  • Testing Data.xlsm
    21.4 KB · Views: 8
Good morning
I put this in it. It was working when if selected the item but when I delete key in the cell C5 then I get the error #N/A.

=LOOKUP(2,1/(testing=$B1),Sheet2!$D$1:$D$40)&""

But now I get the #N/A error? Please fix.

Thank you in advance.
 

Attachments

  • Testing Data.xlsm
    21.4 KB · Views: 2
Good morning
I put this in it. It was working when if selected the item but when I delete key in the cell C5 then I get the error #N/A.

=LOOKUP(2,1/(testing=$B1),Sheet2!$D$1:$D$40)&""

But now I get the #N/A error? Please fix.

Thank you in advance.
Then, add a checking IF function and something like this :

=IF($B1="","",LOOKUP(2,1/(testing=$B1),Sheet2!$D$1:$D$40)&"")

Regards
Bosco
 
RDEXCEL2020
You have skipped Chandoo.org Forum Rules
... eg Cross-posting more than one time ...
Please, reread those rules and follow - those are for You too.
If You have some questions about those rules or anything else ... please ask.
 
Back
Top