Parse a column using a VLOOKUP Table and post a result to another cell/column

[Kerry Facer]

I have a column in of city codes joined with slashes, there may be 2 to 5 codes in a cell.
I need to be able to test or check for a combination against a table then post the result in another cell if the result exists.

Example, the column will contain the following data:

AMS/PHL/SFO

AMS/FRA/PHL/LAX

FCO/LHR/PHL


I have a table set up as follows:

AMS/PHL 1

FRA/PHL 1

LHR/PHL 1


I need the top grouping to check against the bottom table and return a value as a VLOOKUP would (1) or to return the actual value checked in the lower table.

 

[Kerry Facer]

I have a column in of city codes joined with slashes, there may be 2 to 5 codes in a cell.

I need to be able to test or check for a combination against a table then post the result in another cell if the result exists.



Example, the column will contain the following data:



AMS/PHL/SFO



AMS/FRA/PHL/LAX



FCO/LHR/PHL





I have a table set up as follows:



AMS/PHL 1



FRA/PHL 1



LHR/PHL 1





I need the top grouping to check against the bottom table and return a value as a VLOOKUP would (1) or to return the actual value checked in the lower table.

THANKS!!Worked,perfect!