=LOOKUP (show a blank if not available)

K

kermitforney

Have a few LOOKUP arguments setup in a sheet. I need for it to show
blank if there is no value instead of the #N/A error. Anyone know ho
to do this
 
K

kermitforney

Thanks guys!

I am familiar with ISERROR but I was wondering if there was anothe
way.

Just curious I guess. hehe.:
 
A

akyurek

Care to post the LOOKUP formula you have if it's indeed one with the
LOOKUP function?
 
P

Pete_UK

You could try:

=IF(ISNA(LOOKUP(formula),"",LOOKUP(formula))

This will only replace #N/A with "", but will report other errors.

Hope this helps.

Pete
 
K

kermitforney

GaryE said:
instead of iserror you could use

if(isblank(lookup(....),"",lookup(...))

HTH,

Gary


-I tries ISBLANK in the same syntax you have shown above but for som
reason it still show a 0? Not sure why but there is no error it jus
displays a -0. :rolleyes
Click to expand...
 
Top