View Single Post
 
Old 08-12-2015, 11:37 AM
Neydo222 Neydo222 is offline Mac OS X Office for Mac 2011
Novice
 
Join Date: Aug 2015
Posts: 1
Neydo222 is on a distinguished road
Default How to compare two columns and match data

Hi there,

I was hoping for some help to make my life a lot easier using Excel...

So essentially if I have two excel sheets, one with two columns (names and phone numbers), and another with just names, is there any way for me to compare the two, so I can find the phone numbers of all the names that are in both?

I presume there will be a really easy way to do this - I just have no idea how!

Thank you in advance
Reply With Quote