Hello
I am trying to come up with a formula that will allow me to check whether a particular text string exists in a cell and if it does write that value in the adjacent cells.
To explain, I have a column containing about 50k text phrases. I have another column on a separate worksheet containing about 7k place names. I want to check every cell in the first column to see if there are any occurences of any of the place names from the second list. If there is a match then the value from the second list should be written to the adjacent cell in the first list. I have attached a sample workbook to clarify.
The lookup needs to be case insensitive but should only match whole words (ie london should match with London but chester should not match with Manchester). Also some of the place names in the second list are multiple words.
Any assistance greatly appreciated
Howard
Bookmarks