Replace #N/A error message with text?

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.
 
F

FSt1

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#N/A Conversion 1
Excel Import Comments 3
VLOOKUP forumla for Excel HELP! 1
Can't Explain N/A in Vlookup 2
Replace N/A error with zero (0) without losing VLookup function 1
error #N/A 8
Formula Using Vlookup & Match 3
Excel Is this possible?? 3

Top