0 value in null value cell
 

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

Thanks,
Todd

0 value in null value cell
 

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


--
Sigmund


"FP Novice" wrote:

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

Thanks,
Todd