Worksheet Function?

K

Krefty

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....
 
J

James Hamilton

Try this....

=if(iserror(vlookup(yourlookupfunction))," ",(vlookup(yourlookupfuntion)))

You can put some text, or nothing between the set of " ".

Also, just check the number of brackets, as you can make a mistake quite
easily on this.


James
 
C

CLR

Replace your formula with this

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

Vaya con Dios,
Chuck, CABGx3
 
D

Dave Peterson

What happens if U42 really holds a 0?

Maybe a slight change would be better:

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

(I got rid of some ()'s, too.)
 
C

CLR

Uh-huh, maybe..........I suppose it boils down to what is in the "unused"
cell, maybe the OP don't want "either" a "" or a 0 to return 0, then

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

(I gave the OP back their ()'s.....some folks just feel more comfortable
with them)<g>

Vaya con Dios,
Chuck, CABGx3
 
C

CLR

You're welcome Krefty, but read on.........Dave's adaptation might be more
to your liking, or even my second offering........

Vaya con Dios,
Chuck, CABGx3
 
D

Dave Peterson

I don't think you need the "or" at all. Just checking for 0 will pick up the
"empty" 0 and the "real" 0.

So it's back to your original or the minor modification version.
 
C

CLR

Good point Dave................actually any of the three might serve the
OP's purpose.........

Vaya con Dios,
Chuck, CABGx3
 
Top