Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Setting to stop error messages from showing?
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 "#N/A"...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: http://www.excelforum.com/member.php...o&userid=19579 View this thread: http://www.excelforum.com/showthread...hreadid=516347 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Setting to stop error messages from showing?
Hi JENNYC,
=IF(ISERROR(your formula here),"",your formula here) is one way. Ken Johnson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Setting to stop error messages from showing?
Perfect! thanks Ken!! :) -- JENNYC ------------------------------------------------------------------------ JENNYC's Profile: http://www.excelforum.com/member.php...o&userid=19579 View this thread: http://www.excelforum.com/showthread...hreadid=516347 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Setting to stop error messages from showing?
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)),"",=VLOOKUP($A$1,'[03 Mar06 Finance DOC.xls]IS2'!$A4:$N4,2,FALSE)) -- JENNYC ------------------------------------------------------------------------ JENNYC's Profile: http://www.excelforum.com/member.php...o&userid=19579 View this thread: http://www.excelforum.com/showthread...hreadid=516347 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Setting to stop error messages from showing?
=if(iserror(VLOOKUP($A$1,'[03 Mar06 Finance
DOC.xls]IS2'!$A4:$N4,2,FALSE)),"",VLOOKUP($A$1,'[03 Mar06 Finance DOC.xls]IS2'!$A4:$N4,2,FALSE)) "JENNYC" wrote: 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)),"",=VLOOKUP($A$1,'[03 Mar06 Finance DOC.xls]IS2'!$A4:$N4,2,FALSE)) -- JENNYC ------------------------------------------------------------------------ JENNYC's Profile: http://www.excelforum.com/member.php...o&userid=19579 View this thread: http://www.excelforum.com/showthread...hreadid=516347 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Setting to stop error messages from showing?
Hi JENNYC,
I should have mentioned to drop the equals sign, as Sloth has indicated. Thanks Sloth. Ken Johnson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop Toolbar from automatically showing up? | Excel Discussion (Misc queries) | |||
Stop excel icon showing at the bottom when opening spreadsheets | Excel Discussion (Misc queries) | |||
Stop excel icon showing at the bottom when opening spreadsheets | Excel Discussion (Misc queries) | |||
Stop % showing in outcome of formula | Excel Worksheet Functions | |||
How do I stop the Reviewing toolbar from showing up in Excel? | Excel Discussion (Misc queries) |