Replace your formula with this

=IF(('Daily Input'!U42)=0,"",('Daily Input'!U42))

Vaya con Dios,
Chuck, CABGx3


"Krefty" wrote in message
...
Thanks in advance for reading this. I have a lookup function returning
whatever sheet (X) has from a specific cell. I would like it to return
nothing if I am not useing that cell, right now it brings in a 0?

=('Daily Input'!U42) This is the actual command that I am using....