Fetch text by match, verify text is somewhere in another cell, return true / false

Hi Everyone,

I have a little case I hope that you can help me with

as in the title " Fetch text by match, verify text is somewhere in another cell, return true / false "

The attachment describes the process well I think.

if your Members only have a single city in the "City's" column, per ex., then:

=ISNUMBER(SEARCH(VLOOKUP($D3;$A$5:$B$19;2;0)&"/";$B3&"/"))

if, conversely, you could have multiple cities - e.g. Frankfurt/Dublin, then:

=ISNUMBER(LOOKUP(9.99E+307;SEARCH(TRIM(MID(SUBSTITUTE(VLOOKUP($D3;$A$5:$B$19;2;0);"/";REPT(" ";100));1+100*(ROW(A$1:INDEX(A:A;1+LEN(VLOOKUP($D3;$A$5:$B$19;2;0))-LEN(SUBSTITUTE(VLOOKUP($D3;$A$5:$B$19;2;0);"/";""))))-1);100))&"/";$B3&"/")))

the above will search for each city and return True if any one City is found in the "route" string

Thank you very much XLent, it works perfectly