Not quite the same lookup?
 

I have a column of data which contains location information in two separate
spreadsheets.



Problem is that the text entries are not exactly the same in each case, so
one spreadsheet might contain say 'London Acton', and the other might
contain 'Acton', and in other cases they may be identical. Unfortunately
the variations are not always this simple, so that rules out a text to
columns solution.



I want to be able to use one column as a lookup for the other such that if
the first (London Acton) contains the second (Acton) in any part it will
return a +ve/True condition and if not a -ve/False.



Similar to - If String 1 contains String 2 return Yes, Else No.



Where String 2 could be any one of 100 or so possibles.



How can I do this?