Hello all and thank you for having a look here!
I have two columns of text data: column A within file 1.xlsx contains text strings with variations. Column A in file 2.xlsx contains a a simplified range of the same with only one word in a cell. Column B in the same file contains the real name I want to get. Visually the data looks like this:
File 1:

File 2

I need a formula to check if the items from column A of file 2 appear in column A of file 1 - and if true, to get as result the name of the item on the same row in column B. name - e.g. only apple or peach. I'm not sure how to adjust the classic vlookup, as I need to search within a text string and not directly a cell.
All columns contain about 300 items.
Thank you in advance for your help.
I have two columns of text data: column A within file 1.xlsx contains text strings with variations. Column A in file 2.xlsx contains a a simplified range of the same with only one word in a cell. Column B in the same file contains the real name I want to get. Visually the data looks like this:
File 1:

File 2

I need a formula to check if the items from column A of file 2 appear in column A of file 1 - and if true, to get as result the name of the item on the same row in column B. name - e.g. only apple or peach. I'm not sure how to adjust the classic vlookup, as I need to search within a text string and not directly a cell.
All columns contain about 300 items.
Thank you in advance for your help.