| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Vlookup with IF statements
Hello there,
I have tried running a nested IF statement with 15 IF clauses. We all know that excel accepts upto a maximum of 7. I need a way to work around this problem. I am sure there is a VLOOKUP solution to this problem. Below is the IF statment I am using. =IF(ISNUMBER(SEARCH("#",D2)),"COUNTRYSTOCK",IF(ISN UMBER(SEARCH("404- BU",D2)),"PACIFIC",IF(ISNUMBER(SEARCH("404- VI",D2)),"PACIFIC",IF(ISNUMBER(SEARCH("404- CA",D2)),"WEST",IF(ISNUMBER(SEARCH("404- ED",D2)),"WEST",IF(ISNUMBER(SEARCH("404- SA",D2)),"WEST",IF(ISNUMBER(SEARCH("404- WI",D2)),"WEST",IF(ISNUMBER(SEARCH("404- M1",D2)),"CENTRAL",IF(ISNUMBER(SEARCH("404- M2",D2)),"CENTRAL",IF(ISNUMBER(SEARCH("404- LO",D2)),"CENTRAL",IF(ISNUMBER(SEARCH("404- OT",D2)),"EAST",IF(ISNUMBER(SEARCH("404- MO",D2)),"EAST",IF(ISNUMBER(SEARCH("404- SH",D2)),"EAST",IF(ISNUMBER(SEARCH("404- QU",D2)),"EAST",IF(ISNUMBER(SEARCH("404- MJ",D2)),"EAST",IF(ISNUMBER(SEARCH("404- DA",D2)),"ATLANTIC","FALSE")))))))))))))))) I would appreciate if someone could help me get stated on this. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup with AND, OR IF statements | Excel Worksheet Functions | |||
| Help with Vlookup and If Statements | Excel Discussion (Misc queries) | |||
| can I use =if with vlookup statements | Excel Worksheet Functions | |||
| VLOOKUP + IF STATEMENTS | Excel Discussion (Misc queries) | |||
| VLOOKUP statements | Excel Discussion (Misc queries) | |||
Threaded Mode
