Hello everyone!

I want to lookup the text in column A in the text in column B and then return the text in Column A as a result. How do I do that?

Here's the table:

Column A Column B Desired Result
new york vacation in london london
london holiday in new york new york

Thanks in advance for your help!

Roshni