Hello, I am trying to get a formula to read the following...I have come close
to getting the answer I need, but am not quite there yet! Any help would be
much appreciated

Coloumn A contains various locations in the UK, written like - England,
South East, London, Hammersmith. Then the next line contains - England,
South, South West, Devon.

There is no consistancy in the number of words that are used, but I have a
list of UK towns in Coloumn C with a corresponding town reference in coloumn
D, for example London in C, then 123 in D.

I am trying to enter a formula in a new coloumn that shows - if coloumn A1
contains any on the UK towns listed in coloumn C (there are about 50 of them)
then show the number that is in coloumn D next to that town in my new
coloumn. I then want to copy this formula down so it reads, A2, A3 and so on.

Thank you in advance!