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

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

--
__________________________________
HTH

Bob

"K" wrote in message
...
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

On Jan 12, 12:01*pm, "Bob Phillips" wrote:
=INDEX(A:A,MATCH("*"&E1&"*",B:B,0))

--
__________________________________
HTH

Bob

"K" wrote in message

...



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- Hide quoted text -

- Show quoted text -

Thanks lot