Formula to match words

[K]

Hi all, I have data in column A and B like (see below)

A B------columns
BB School Suzi dd coroc film
CC Tony MR Kent stated Society
DD Chandeliers Fil Section
EE Youth of Generation Prima film

and in column E I have data like (see below)

E -------column
MR Kent
Suzi dd
Prima
Chandeliers

I want some formula in column F which should check column E text in
column B text line and when it match those column E text words in
column B text then it should return column A value. So result will be
something like this

E F---------columns
MR Kent CC
Suzi dd BB
Prima EE
Chandeliers DD

I hope I was able to explain my question. Please can any friend help

 

[Bob Phillips]

=INDEX(A:A,MATCH("*"&E1&"*",B:B,0))

 

[K]

=INDEX(A:A,MATCH("*"&E1&"*",B:B,0))

--
__________________________________
HTH

Bob












- Show quoted text -

Thanks lot