Compare two columns - If the text of one column is present in the other column

Hi,

I need a formula to compare two columns from different tables:
Table 1 has a column (C) with a description and table 2 has a column with a keyword (A) and another column with a type (B).
I need to compare if the keyword from table 2 is present in the description of table 1 and if so return the keyword and the type in another column.

Example:

Table 1

Column C (Description)
Apple Pie
Orange Juice
Sony TV
Sony Laptop

Table 2

Column A (Keywords) -------- Column B (Type)
Apple ------------------------- Food
Orange ------------------------Food
Sony --------------------------Eletronics

Result on table 1

Column C (Description) -----Column D (Keyword) ----Column E (Type)
Apple Pie -------------------- Apple ---------------------- Food
Orange Juice-------------------Orange ------------------- Food
Sony TV ---------------------- Sony --------------------- Eletronics
Sony Laptop ------------------Sony --------------------- Eletronics

Tks

Hi and welcome to the forum

Your tables and columns are confusing, please upload a sample workbook.

You probably need to use something like...........=iferror(vlookup(A1&"*",

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Hi,

In D2 and copy down, enter this array formula (confirm with CTRL+SHIFT+ENTER, not just ENTER):

=INDEX(Sheet2!$A$2:$A$4,MATCH(TRUE,ISNUMBER(SEARCH(Sheet2!$A$2:$A$4,Sheet1!C2)),0))

In E2 and copy down (normal formula this time):

=VLOOKUP(F2,Sheet2!$A$2:$B$4,2,0)

Regards

You're welcome.