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

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