dont display errors

Richiejjj

Board Regular
Joined
Feb 18, 2002
Messages
237
if i am doing a vlookup -- how can i prevent an error from showing, i would be happy with a dash in its place.

thanks

rich
This message was edited by richiejjj on 2002-03-25 05:47
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
You might try:

=IF(ISNA(VLOOKUP(whatever));"-";VLOOKUP(whatever))

I don't know of any way to format errors.

marc
 
Upvote 0
I would suggest this instead:

If your current formula looks something like:

=VLOOKUP(A1,$C$1:$E$100,3,0)

replace it with

=IF(COUNTIF($C$1:$C$100,A1),VLOOKUP(A1,$C$1:$E$100,3,0),"")
 
Upvote 0
further to the earlier question , how can i adapt this to not show results of formulaes that would produce an error:

i.e. #DIV/0!

thanks
 
Upvote 0
you should be able to tailor the =error.type function to your requirements where you only want to "hide" or "replace" certain types of errors

check out the help file on error types
 
Upvote 0
On 2002-03-25 09:20, Richiejjj wrote:
further to the earlier question , how can i adapt this to not show results of formulaes that would produce an error:

i.e. #DIV/0!

thanks

It's better to prevent occurrence of errors like the one you cite.

=IF(B1,A1/B1,0)

where B1 is of numeric type, is better than just:

=A1/B1

which will give #DIV/0! if B1 can be 0 or empty.
 
Upvote 0

Forum statistics

Threads
1,213,561
Messages
6,114,316
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top