need lookup help with return value

R Flock

New member
Joined
Mar 6, 2015
Messages
2
Reaction score
0
Points
0
I am using lookup to capture the value in a cell, if the lookup cell has not yet been populated, how do I return a value of "blank"
 
Last edited:
Try:

=IF(Your_lookup()="","",You_lookup())

of, if it currently returning an error because the lookup value doesn't exist, then

=IFERROR(Your_Lookup(),"")
 
Back
Top