Syntax to Nest ISERROR with a VLookup

C

Christine

I know I'm being "dense" but have been fighting with the correct syntax to
add an ISERROR forumla to my VLookup. Can someone please give me the correct
formula?

My VLookup is: =VLOOKUP(E2,County!A:B,2) and I would like to add the
following text in the case of an error "Street not found".

Thanks so much for your help......if I don't get it soon I won't have any
hair left :)

Christine
 
E

E-Coder

=IF(ISERROR(VLOOKUP(E2,County!A:B,2)),"Street not
found",VLOOKUP(E2,County!A:B,2))
 

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

ISERROR on VLOOKUP 3
Vlookup Returning Zero For Every Cell 3
Source information from different sheets with vlookup 0
Iserror with if(or & Vlookups 5
Can I add a formula or function to Vlookup? 1
Using Iserror with If statement and Vlookup 3
VLOOKUP displaying "NO ANSWER" instead of "0" 2
VLookup Won't Copy down (#REF! error) 1

Top