Re: Excel Help
Posted 6/11/2013 2:32:35 PM by BellyBlessings

vlookup is the absolute best way to do this...

If you aren't comfortable with functions, you can also combine both lists to one spreadsheet, make sure the same info is in the same columns (all last names in the same column, all first names in the same column...) highlight the last name column and select conditional formatting in the home tab, highlight cell rules, duplicate values, then click OK. This highlights all last names with that are duplicated. You can then filter out the highlighted names and have what you are looking for. Then, with some copying and pasting, have the results you need!

I can also do this for you if you like.
Print Post      Close Window