Join 2 tables on name

[JDong]

Hi Team,

I have a column with following data :

Fruits

Apple

Banana

Avacado

Cherry

I have to join to another table based on this column but with CONTAINS kind of logic

Fruits

Bananen

Bana

Bananas

Cherry EMEA

Pine apple

Pineapples

Apples

Apple South

Big Apple

In output on joining both columns it needs to retreive all the matching data with contains logic something like

CONTAINS('Apple') then return the below and also needs to check only start with 

Apples

Apple South

Big Apple

Thanks

[Luke_C · Accepted solution]

Hi @JDong 

Using the 'Append' option of the find and replace tool might be an easy solution, it will add a column and indicate what matched. You can then filter or use that column however you need.

[Emil_Kos]

Hi @JDong,

Did you check the find and replace the tool? 

There is the possibility to check also if the cell starts with the word that you are searching for. Give it a try and let me know if this brings you the desired output. 

Just additional comment find and replace works very similar to vlookup so if you are familiar with this function think about find and replace tool like a vlookup on steroids.