Even though colB will not exactly match ColA - if any part of the cell
contents in column b matches any part of the cell contents in column A I
need
to know. Is there a way to do this.

Not that I know of. You can't be that general, "if any part matches any
part". You have to search for specific substrings.

Based on the last sample you posted I didn't see anything that even closely
matched. (other than DR and I'm guessing that isn't a match)

can you explain your answer

The formula just searches for entire words that have a space before and
after. That way, Mark and Markson can't be a match.

If the cell contents was:

Mark Adams

There obviously isn't a space before Mark so the formula concatenates a
space to the beginning and to the end of the cells contents.

Biff

"Rookie_User" wrote in message
...
WOW, that is so awesome thank you. Now that you got me 95% of the way
there
can you maybe make one more modifcation to accomplish the next iteration.
The same situation above, heres the data, I changed it from above but I
just
need to do one more iteration to "tune" our numbers. So, in this example

Quotes Column A Order -Column B

Amy Woo ~-060251-a 113028-Herb Mills ICC
Adams Dr Art ~-060229-a 113283-Dr Jason Daaboul ICC
Alan Mills ~-050810-d 113376-Hortman ICC
Allan-Dr. Finney ~-050510-b 113401-HedrickDodson ICC
Abbot ~-060174-a 113422-JVH-Cooper-06 ICC
Advanced Endodontics-060171-a 113466-Lacy ICC
Arrington ~-060152-a 113496-Drs Cross-Wan Burns ICC

Even though colB will not exactly match ColA - if any part of the cell
contents in column b matches any part of the cell contents in column A I
need
to know. Is there a way to do this. Additionally, if you have time can
you
explain your answer, your formula is awesome you gave me before but I
can't
understand it. If it takes too much time don't worry about it. I am
trying
to get these results early this moring PST time.
"Biff" wrote:

That could return false positives:

Eric Sampson............Sam
Alice Markson...........Mark

A little more robust: (but still not 100% bulletproof)

=IF(SUMPRODUCT(--(ISNUMBER(SEARCH(" "&B1&" "," "&A$1:A$10&"
")))),"Yes","No")

Biff

"CLR" wrote in message
...
In C1 put this and copy down..........

=IF(COUNTIF(A:A,"*"&B1&"*")0,"Found in column A is yes","Not found")

Vaya con Dios,
Chuck, CABGx3



"Rookie_User" wrote:

I have two columns of data and I want to know where column one's data
exists
in column two. It is not as easy as just using a countif function or
anything. Please see my data set. Column C is just used to see if it
exists. Please help.

A B C
Jason Hopson Jason Found in Column A is yes
Jack Alan Sam Found in Column A is yes
Mark Bran Noelia Found in Column A is yes
Noelia Sam Tina Not found
Sam Zink