| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Vlookup for IF statements
Hello there,
I have a rather long IF statement, and as we all know that Excel only accepts upto 7 IFs statments within the nest. IF(ISNUMBER(SEARCH("#",D2)),"COUNTRYSTOCK",IF(ISNU MBER(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")))))))))))))))) Above is my IF statement. Basically it is looking at a part of a string in column and using a condition. I am not sure about the Vlookup formula. I have a hunch I could use it in place of this. Can someone help me get started on it? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP and IF Statements | Excel Discussion (Misc queries) | |||
| 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
