Formula to match words
 

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

Formula to match words
 

Hi

=IF(LEN(SUBSTITUTE($B1;$E1;""))=LEN($B1);"";A1)


Arvi Laanemets


"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

Formula to match words
 

On Jan 12, 11:46*am, "Arvi Laanemets" wrote:
Hi

=IF(LEN(SUBSTITUTE($B1;$E1;""))=LEN($B1);"";A1)

Arvi Laanemets

"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