Hello
I am having trouble searching for multiple text strings in a list and returning the correct text string if it appears.
I have a reference list as below
Reference List
London
Cardiff
Exeter
Bristol
And a data list
Data List
London
Cardiff City Centre
City of London...