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.