Thread: vlookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Wilson Wilson is offline
external usenet poster
 
Posts: 18
Default 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