Text and extracting certain words from formula

[jw01]

Hi there

I have a range of codes in sheet name "Airport" column I (I2:I350).

They appear like this: JFK-IKA-DOH or DOH-SGN-PNH-SGN-DOH

In sheet name "Lookup" column A2:A285, I have what each 3 letter code means (it's airport code).

WHat formula can I use so for each code in I2:I350, it matches the "2nd" 3 digit code with what is in the "Lookup column range A2:A285

Can anyone help?

THank you

[Tony Valko]

Can you post a SMALL sample file and show us what results you expect?

20 rows and a few columns worth of data is plenty. We don't need 100's of rows and dozens of columns of data. That just makes it harder to find what we're looking for!

[Kerryx]

try this , if my understanding is correct, assuming A2: A285 has the matching airport code and column B has the airport name
put this formula into j2 and fill down.

=VLOOKUP(MID(I2,5,3),Lookup!A2:A285,2,FALSE)