I still can't work out from your descriptions in which cells your tables are (I don't understand the L1-L5 references?), but assuming the second table is in A1:E5, such that *Gopal* is in A1 and *San Jose* in E5, and that your results table is in G1:G4, then, in H1:

If you're using Excel 2010 or later:

=INDEX($E$1:$E$4,AGGREGATE(15,6,ROW($A$1:$D$4)/ISNUMBER(SEARCH(" "&$A$1:$D$4&" "," "&G1&" ")),1))

Otherwise, **array formula****:

=INDEX($E$1:$E$4,MIN(IF(ISNUMBER(SEARCH(" "&$A$1:$D$4&" "," "&G1&" ")),ROW($A$1:$D$4))))

Copy down to give similar results for the strings in G2, G3 and G4.

Regards

***Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).*