0 value in null value cell

  • Thread starter Thread starter FP Novice
  • Start date Start date
F

FP Novice

How do I stop a 0 from showing up in a cell running a lookup function when
there is a null value?

Thanks,
Todd
 
Hi,
you can use and If statement so can eliminate the 0 or null
Try and let me know

=IF(LOOKUP(C3,F3:I4)=0," ",LOOKUP(C3,F3:I4))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sorting: cleared/null v/s "" 3
Windows 10 Error: 'CreateProcessWithTokenW' was not declared in this scope 2
VLOOKUP 10
Weighted randbetween text list 3
Use specialcells to identify specific values 1
Null value in excel 4
Count unique values in one column if values in corresponding columnare null? 1
Find value in another column, change Interior.colorIndex 4

Back
Top