Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Syntax to Nest ISERROR with a VLookup
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Syntax to Nest ISERROR with a VLookup
=IF(ISERROR(VLOOKUP(E2,County!A:B,2)),"Street not
found",VLOOKUP(E2,County!A:B,2)) "Christine" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Syntax to Nest ISERROR with a VLookup
Thank you so much.
Christine "E-Coder" wrote: =IF(ISERROR(VLOOKUP(E2,County!A:B,2)),"Street not found",VLOOKUP(E2,County!A:B,2)) "Christine" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Syntax to Nest ISERROR with a VLookup | Excel Worksheet Functions | |||
Nest vlookup within large function | Excel Worksheet Functions | |||
Iserror and vlookup | Excel Worksheet Functions | |||
ISERROR VLOOKUP | Excel Worksheet Functions | |||
Iserror and Vlookup | Excel Worksheet Functions |