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
|