Formula to match words

K

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top