software

Hi there! Is there a way to stop the error messages from showing?

For example: I have a table that is pulling info from another sheet
(using formulas in ea cell)...in the cells that DO NOT pull info over
they come up as quot;#N/Aquot;...is there any way for me to tell excel to just
NOT give me an error message...leaving it blank instead?--
JENNYC
------------------------------------------------------------------------
JENNYC's Profile: www.excelforum.com/member.php...oamp;userid=19579
View this thread: www.excelforum.com/showthread...hreadid=516347Hi JENNYC,
=IF(ISERROR(your formula here),quot;quot;,your formula here)
is one way.
Ken Johnson
Perfect! thanks Ken!! --
JENNYC
------------------------------------------------------------------------
JENNYC's Profile: www.excelforum.com/member.php...oamp;userid=19579
View this thread: www.excelforum.com/showthread...hreadid=516347
I spoke too soon! Here's the formula i'm trying...and it tells me the
formula contains an error...is it maybe becasue you can't do that when
using VLOOKUP? Or did i miss something?....

=if(iserror(=VLOOKUP($A$1,'[03 Mar06 Finance
DOC.xls]IS2'!$A4:$N4,2,FALSE)),quot;quot;,=VLOOKUP($A$1,'[03 Mar06 Finance
DOC.xls]IS2'!$A4:$N4,2,FALSE))--
JENNYC
------------------------------------------------------------------------
JENNYC's Profile: www.excelforum.com/member.php...oamp;userid=19579
View this thread: www.excelforum.com/showthread...hreadid=516347=if(iserror(VLOOKUP($A$1,'[03 Mar06 Finance
DOC.xls]IS2'!$A4:$N4,2,FALSE)),quot;quot;,VLOOKUP($A$1,'[03 Mar06 Finance
DOC.xls]IS2'!$A4:$N4,2,FALSE))

quot;JENNYCquot; wrote:

gt;
gt; I spoke too soon! Here's the formula i'm trying...and it tells me the
gt; formula contains an error...is it maybe becasue you can't do that when
gt; using VLOOKUP? Or did i miss something?....
gt;
gt; =if(iserror(=VLOOKUP($A$1,'[03 Mar06 Finance
gt; DOC.xls]IS2'!$A4:$N4,2,FALSE)),quot;quot;,=VLOOKUP($A$1,'[03 Mar06 Finance
gt; DOC.xls]IS2'!$A4:$N4,2,FALSE))
gt;
gt;
gt; --
gt; JENNYC
gt; ------------------------------------------------------------------------
gt; JENNYC's Profile: www.excelforum.com/member.php...oamp;userid=19579
gt; View this thread: www.excelforum.com/showthread...hreadid=516347
gt;
gt;

Hi JENNYC,
I should have mentioned to drop the equals sign, as Sloth has
indicated. Thanks Sloth.
Ken Johnson