searching text values in two columns

  • Thread starter Thread starter destrolennox
  • Start date Start date
D

destrolennox

Hello,

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

-Brenda
 
Back
Top