|
Worksheet Function?
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.... |
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 "Krefty" wrote: 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.... |
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.... |
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.) CLR wrote: 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.... -- Dave Peterson |
Thank You
"CLR" wrote: 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.... |
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 "Dave Peterson" wrote in message ... 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.) CLR wrote: 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.... -- Dave Peterson |
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 "Krefty" wrote in message ... Thank You "CLR" wrote: 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.... |
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. CLR wrote: 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 "Dave Peterson" wrote in message ... 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.) CLR wrote: 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.... -- Dave Peterson -- Dave Peterson |
Good point Dave................actually any of the three might serve the
OP's purpose......... Vaya con Dios, Chuck, CABGx3 "Dave Peterson" wrote in message ... 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. CLR wrote: 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 "Dave Peterson" wrote in message ... 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.) CLR wrote: 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.... -- Dave Peterson -- Dave Peterson |
| All times are GMT +1. The time now is 02:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com