searching text values in two columns
 

Hello,

I have 2 columns in a spreadsheet containing names of people. About
75% of the names in column B are also located in column A. I want to
see which names are located in both columns. I tried to create a
formula in column C using the lookup function. However, it runs into
problems when looking for names such as Smith and Smithfield. Is there
a better search formula to use in my case? Thanks for all the help.

-Brendan


--
destrolennox
------------------------------------------------------------------------
destrolennox's Profile: http://www.excelforum.com/member.php...o&userid=36503
View this thread: http://www.excelforum.com/showthread...hreadid=570968

searching text values in two columns
 

see duplicates on
Conditional Formatting
http://www.mvps.org/dmcritchie/excel...htm#duplicates

This question was answered in the actual newsgroup not by
usurpers of newsgroups that mess up Google web searches.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"destrolennox" wrote:
I have 2 columns in a spreadsheet containing names of people. About
75% of the names in column B are also located in column A. I want to
see which names are located in both columns. I tried to create a
formula in column C using the lookup function. However, it runs into
problems when looking for names such as Smith and Smithfield. Is there
a better search formula to use in my case? Thanks for all the help.