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