One way:

=IF(ISNA(VLOOKUP(...)),"invalid",VLOOKUP(...))


In article ,
ashley wrote:

HI,
This is my formula. It works fine. But instead of #N/A if there is not an
exact match. I would like to put a text "invalid". How to add the text to
this formula.
=VLOOKUP(D41,$W$37:$X$47,2,FALSE)

Thanks