Change #VALUE! to Own Message

  • Thread starter Thread starter jennie277
  • Start date Start date
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
 
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))
 
Back
Top