Syntax to Nest ISERROR with a VLookup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Christine - 08 Mar 2007 19:32 GMT

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

Reply to this Message

E-Coder - 08 Mar 2007 20:06 GMT

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

> 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
[quoted text clipped - 7 lines]
>
> Christine

Reply to this Message

Christine - 08 Mar 2007 20:36 GMT

Thank you so much.

Christine

> =IF(ISERROR(VLOOKUP(E2,County!A:B,2)),"Street not
> found",VLOOKUP(E2,County!A:B,2))
[quoted text clipped - 10 lines]
> >
> > Christine

Reply to this Message