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