=LOOKUP (show a blank if not available)
 

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


--
kermitforney
------------------------------------------------------------------------
kermitforney's Profile: http://www.excelforum.com/member.php...o&userid=32536
View this thread: http://www.excelforum.com/showthread...hreadid=523669

=LOOKUP (show a blank if not available)
 

Try this...
=IF(ISERROR(LOOKUP(formula),"",LOOKUP(formula))


--
kraljb
------------------------------------------------------------------------
kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955
View this thread: http://www.excelforum.com/showthread...hreadid=523669

=LOOKUP (show a blank if not available)
 

You could use something like this:

=IF(ISERROR(LOOKUP()),"",LOOKUP())

HTH,
Elkar


"kermitforney" wrote:


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


--
kermitforney
------------------------------------------------------------------------
kermitforney's Profile: http://www.excelforum.com/member.php...o&userid=32536
View this thread: http://www.excelforum.com/showthread...hreadid=523669

=LOOKUP (show a blank if not available)
 

Thanks guys!

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

Just curious I guess. hehe.:)


--
kermitforney
------------------------------------------------------------------------
kermitforney's Profile: http://www.excelforum.com/member.php...o&userid=32536
View this thread: http://www.excelforum.com/showthread...hreadid=523669

=LOOKUP (show a blank if not available)
 

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

=LOOKUP (show a blank if not available)
 

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

=LOOKUP (show a blank if not available)
 

instead of iserror you could use

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

HTH,

Gary


--
GaryE
Posted from - http://www.officehelp.in

=LOOKUP (show a blank if not available)
 

Cool, thanks guys.


--
kermitforney
------------------------------------------------------------------------
kermitforney's Profile: http://www.excelforum.com/member.php...o&userid=32536
View this thread: http://www.excelforum.com/showthread...hreadid=523669

=LOOKUP (show a blank if not available)
 

GaryE Wrote:
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 some
reason it still show a 0? Not sure why but there is no error it just
displays a -0. :rolleyes:


--
kermitforney
------------------------------------------------------------------------
kermitforney's Profile: http://www.excelforum.com/member.php...o&userid=32536
View this thread: http://www.excelforum.com/showthread...hreadid=523669