If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|