Syntax to Nest ISERROR with a VLookup

[Guest]

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

 

[Guest]

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

 

[Guest]

Thank you so much.

Christine

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