Change #VALUE! to Own Message

J

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
 
B

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))
 
Top