Compare Lists
 

My question is kind of difficult for my to explain, But let me try. I have
several lists on different sheets. I want to look for data on list 1 on the
other lists, But I need to find it if it is similar, Like the following
sample:
Sheet 1 A1="Beginning"
Sheet 2 A21="The Beginning"
Sheet 3 A34="Beginning, The"
Sheet 4 A12="From the Beginning"
I am looking for the data contained in Sheet 1 A1"Beginning" in the other
lists, But I dont want it to return the value of Sheet 4 A12"From the
Beginning". In other words, if there is the Word "The" is the only word in
front of the value that I am looking for, return it. Or if any other words
are after the value, return it.
Not sure if I am making sense or not, But I tried.

Compare Lists
 

=SUBSTITUTE(INDEX(Sheet4!A1:A200,MATCH("*"&Sheet1! A1&"*",Sheet4!A1:A200,0)),"Beginning","")

ctrl+shift+enter, not just enter
Adjust to suit

"Lemmesee" wrote:

My question is kind of difficult for my to explain, But let me try. I have
several lists on different sheets. I want to look for data on list 1 on the
other lists, But I need to find it if it is similar, Like the following
sample:
Sheet 1 A1="Beginning"
Sheet 2 A21="The Beginning"
Sheet 3 A34="Beginning, The"
Sheet 4 A12="From the Beginning"
I am looking for the data contained in Sheet 1 A1"Beginning" in the other
lists, But I dont want it to return the value of Sheet 4 A12"From the
Beginning". In other words, if there is the Word "The" is the only word in
front of the value that I am looking for, return it. Or if any other words
are after the value, return it.
Not sure if I am making sense or not, But I tried.

Compare Lists
 

<<"Or if any other words are after the value, return it."

You are saying that you will accept "Beginning Of The Year"?

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Lemmesee" wrote in message
...
My question is kind of difficult for my to explain, But let me try. I have
several lists on different sheets. I want to look for data on list 1 on
the
other lists, But I need to find it if it is similar, Like the following
sample:
Sheet 1 A1="Beginning"
Sheet 2 A21="The Beginning"
Sheet 3 A34="Beginning, The"
Sheet 4 A12="From the Beginning"
I am looking for the data contained in Sheet 1 A1"Beginning" in the other
lists, But I dont want it to return the value of Sheet 4 A12"From the
Beginning". In other words, if there is the Word "The" is the only word in
front of the value that I am looking for, return it. Or if any other words
are after the value, return it.
Not sure if I am making sense or not, But I tried.

Compare Lists
 

Yes

"RagDyer" wrote:

<<"Or if any other words are after the value, return it."

You are saying that you will accept "Beginning Of The Year"?

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Lemmesee" wrote in message
...
My question is kind of difficult for my to explain, But let me try. I have
several lists on different sheets. I want to look for data on list 1 on
the
other lists, But I need to find it if it is similar, Like the following
sample:
Sheet 1 A1="Beginning"
Sheet 2 A21="The Beginning"
Sheet 3 A34="Beginning, The"
Sheet 4 A12="From the Beginning"
I am looking for the data contained in Sheet 1 A1"Beginning" in the other
lists, But I dont want it to return the value of Sheet 4 A12"From the
Beginning". In other words, if there is the Word "The" is the only word in
front of the value that I am looking for, return it. Or if any other words
are after the value, return it.
Not sure if I am making sense or not, But I tried.

Compare Lists
 

YES

"RagDyer" wrote:

<<"Or if any other words are after the value, return it."

You are saying that you will accept "Beginning Of The Year"?

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Lemmesee" wrote in message
...
My question is kind of difficult for my to explain, But let me try. I have
several lists on different sheets. I want to look for data on list 1 on
the
other lists, But I need to find it if it is similar, Like the following
sample:
Sheet 1 A1="Beginning"
Sheet 2 A21="The Beginning"
Sheet 3 A34="Beginning, The"
Sheet 4 A12="From the Beginning"
I am looking for the data contained in Sheet 1 A1"Beginning" in the other
lists, But I dont want it to return the value of Sheet 4 A12"From the
Beginning". In other words, if there is the Word "The" is the only word in
front of the value that I am looking for, return it. Or if any other words
are after the value, return it.
Not sure if I am making sense or not, But I tried.

Compare Lists
 

Yes, or "The Beginnig Of The Year".
But Not From The Beginning Of The Year"

"RagDyer" wrote:

<<"Or if any other words are after the value, return it."

You are saying that you will accept "Beginning Of The Year"?

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Lemmesee" wrote in message
...
My question is kind of difficult for my to explain, But let me try. I have
several lists on different sheets. I want to look for data on list 1 on
the
other lists, But I need to find it if it is similar, Like the following
sample:
Sheet 1 A1="Beginning"
Sheet 2 A21="The Beginning"
Sheet 3 A34="Beginning, The"
Sheet 4 A12="From the Beginning"
I am looking for the data contained in Sheet 1 A1"Beginning" in the other
lists, But I dont want it to return the value of Sheet 4 A12"From the
Beginning". In other words, if there is the Word "The" is the only word in
front of the value that I am looking for, return it. Or if any other words
are after the value, return it.
Not sure if I am making sense or not, But I tried.