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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup
Your reply
If your text is in C10 and your lookup valUe(IAX) is in C8 then this formula =LEFT(MID(C10,FIND(C8,C10,1),LEN(C10)),3). You can change this to reflect your situation. The FIND function finds your text in cell C8, alternatively you can type the text in quotes. The text is searched in C10 (starting from the first letter-1)or where ever you put it. The figure 3 is the number of your search string(IAX) "wilson" wrote: 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 |
Reply |
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 |