| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup
Hi,
I have some strings of data that is structured like this manner +AHS-CT+NS9-IAX+NC7-TR+CHS-CT+CHR +AHS-CT+NS9-IAX+NC7-TR+CHS +AHS-CT+NSH-SSX+SIN-PS1+SEA-TR+POR +AHS-CT+NSH-SSX+SIN-SAX+SPQ I need something that will lookup for example IAX, PS1, SAX and some other values that I have, and then display the next 3 letter code that is immidiately after the lookup values. Example, for string one, for the lookup to find IAX and then display the value NC7 which is immediately after it. Thanks alot! Best Regards Wilson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
| Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Threaded Mode
