Change #VALUE! to Own Message

[jennie277]

Hi

Is there any way to change the #VALUE! error when it is shown, to show
a set message such as "Number not Used" or an set value that is outside
the data range, instead?

Thanks
Jennie

 

[BrianB]

You may need to show which formula you are using.

The general method is to use one of the "IS" functions something like
:-
=IF(ISERROR(VLOOKUP(A1,B1:C20,2,FALSE)),0,VLOOKUP(A1,B1:C20,2,FALSE))

 

[jennie277]

Hi

The ISERROR worked a treat

Thanks for your help
Jennie