Replace #N/A error message with text?

  • Thread starter Thread starter Munchkin
  • Start date Start date
M

Munchkin

=VLOOKUP($A$3,PolicyList,9,FALSE)

If no match is found based on what is entered in A3 "#N/A" appears in the
cell where my forumula is. I want "Match not found" to be displayed instead
- can I do that and if so how.
 
hi
try this..
=IF(ISERROR(VLOOKUP($A$3,PolicyList,9,FALSE)),"No Match
Found",VLOOKUP($A$3,PolicyList,9,FALSE))


watch out. the above formula wrapped.

Regards
FSt1
 
Back
Top