Find values from a list and show it

Hi Excel-Forum, I've the following question: My table has a row containing many different informations. There is no certain pattern in it. The row has 20.000 lines, so there is a lot of information. I know that many of these lines contain city names. So the entry looks like:

"Glock Karlsruhe ua.", "Mohl Tübingen ua." or "Talbot Paris ua." etc.

Now, I need a formula which compares this row with a new list of specific city names, e.g. Munich, Paris, London, New York. If there is a match Excel should give me the value in the row next to line.

Thank you for your help, Fabian

Hi Fabian and welcome.

Could you post an example file showing some of your data and your expected results?

To attach a sample workbook click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

BSB

Hi BSB,

I attached the file. Thank you very much!

Fabian