0 value in null value cell

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
 
S

Sigmund

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))
 
Top