lookup multiple values(strings) in a single cell with col A & B(diff sheet) & return col B

HI Guys,

I can't find a solution to my problem after browsing through numerous posts and threads. Kindly help me out

In the sheet attached, i want to get the "Ranking" in column B of sheet 1 by looking up city (col A sheet 1) with col a and B of sheet 2 and return value in col B(ranking)

Its easy to do a vlookup when the cell contains one value for eg: "Houston" can be looked up from sheet 2

But some of my cells contain: Houston;Miami;Seattle in one cell and i want to get the value of the city which has the highest rank among the three.

Is this possible? Let me know if you need more clarity on this. I have attached the excel file with the post.
Thanks in advance