match each value in a column with another column which contains column1 as one word or pattern match

[flames]

Hi I have two columns in two excels...

excel1 
---------

COL1

WIRE

DISH

BLANKET

BAG

DO

HNET

INTNET

KITCHEN

excel2

---------

COL2

NOMATCHING

WIRED

WIRE TECHNOLOGIES

DISH NETWORKS

BAGGAGE

DOING

INTERNET

GOOGLE

APPLE

NETFLIX

FACEBOOK

AMAZON

DELL

MAC

CLEAR

JNJ

CAT

JIO

LEVIS

Now i need to check if each word from COL1 as a match %like% in COL2 .. result should be like this,,,

COL2	COL3
NOMATCHING
WIRED	WIRE
WIRE TECHNOLOGIES	WIRE
DISH NETWORKS	DISH
BAGGAGE	BAG
DOING	DO
INTERNET
GOOGLE
APPLE
NETFLIX
FACEBOOK
AMAZON
KITCHENWARE	KITCHEN
MAC
CLEAR
JNJ
CAT
JIO
HNET TECH	HNET

appreciate your help. 

[Dalton_Ruer]

Wildmatch will be your friend. 

[Saravanan_Desingh]

Try this,

COL1:
LOAD * INLINE [
    COL1
    WIRE
    DISH
    BLANKET
    BAG
    DO
    HNET
    INTNET
    KITCHEN
];

COL2:
LOAD * INLINE [
    COL2
    NOMATCHING
    WIRED
    WIRE TECHNOLOGIES
    DISH NETWORKS
    BAGGAGE
    DOING
    INTERNET
    GOOGLE
    APPLE
    NETFLIX
    FACEBOOK
    AMAZON
    DELL
    MAC
    CLEAR
    JNJ
    CAT
    JIO
    LEVIS
];

[Saravanan_Desingh]

Dim:

COL2

Exp:

Pick(WildMatch(COL2,$(=Concat('''*'&COL1&'*''',','))),$(=Concat(Chr(39)&COL1&Chr(39),',')))

Output: