dont display errors

[Richiejjj]

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

 

[paelinck]

You might try:

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

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

marc

 

[Juan Pablo González]

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),"")

 

[Richiejjj]

excellent thank you

 

[Richiejjj]

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

 

[Chris Davison]

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

 

[Aladin Akyurek]

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.

 

[Richiejjj]

great thanks!