software

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: www.excelforum.com/member.php...oamp;userid=32536
View this thread: www.excelforum.com/showthread...hreadid=523669
Try this...
=IF(ISERROR(LOOKUP(formula),quot;quot;,LOOKUP(formula))--
kraljb
------------------------------------------------------------------------
kraljb's Profile: www.excelforum.com/member.php...foamp;userid=9955
View this thread: www.excelforum.com/showthread...hreadid=523669You could use something like this:

=IF(ISERROR(LOOKUP()),quot;quot;,LOOKUP())

HTH,
Elkarquot;kermitforneyquot; wrote:

gt;
gt; Have a few LOOKUP arguments setup in a sheet. I need for it to show a
gt; blank if there is no value instead of the #N/A error. Anyone know how
gt; to do this?
gt;
gt;
gt; --
gt; kermitforney
gt; ------------------------------------------------------------------------
gt; kermitforney's Profile: www.excelforum.com/member.php...oamp;userid=32536
gt; View this thread: www.excelforum.com/showthread...hreadid=523669
gt;
gt;


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: www.excelforum.com/member.php...oamp;userid=32536
View this thread: www.excelforum.com/showthread...hreadid=523669Care to post the LOOKUP formula you have if it's indeed one with the
LOOKUP function?You could try:

=IF(ISNA(LOOKUP(formula),quot;quot;,LOOKUP(formula))

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

Hope this helps.

Pete
instead of iserror you could use

if(isblank(lookup(....),quot;quot;,lookup(...))

HTH,

Gary--
GaryE
Posted from - www.officehelp.in
Cool, thanks guys.--
kermitforney
------------------------------------------------------------------------
kermitforney's Profile: www.excelforum.com/member.php...oamp;userid=32536
View this thread: www.excelforum.com/showthread...hreadid=523669
GaryE Wrote:
gt; instead of iserror you could use
gt;
gt; if(isblank(lookup(....),quot;quot;,lookup(...))
gt;
gt; HTH,
gt;
gt; Gary
gt;
gt;
gt; -I tries ISBLANK in the same syntax you have shown above but for some
gt; reason it still show a 0? Not sure why but there is no error it just
gt; displays a -0. --
kermitforney
------------------------------------------------------------------------
kermitforney's Profile: www.excelforum.com/member.php...oamp;userid=32536
View this thread: www.excelforum.com/showthread...hreadid=523669