Microsoft Office Forums How to compare two columns and match data
 Register FAQ Search Today's Posts Mark Forums Read

#1
08-12-2015, 11:37 AM
 Neydo222 Mac OS X Office for Mac 2011 Novice Join Date: Aug 2015 Posts: 1
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!

#2
08-12-2015, 11:51 AM
 Pecoflyer Windows 7 64bit Office 2010 64bit Moderator Join Date: Nov 2011 Location: Brussels Belgium Posts: 2,292

Hi

an easy way ? I'll let you be the judge of that . See http://www.get-digital-help.com/2009...rom-two-lists/
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
#3
09-12-2015, 02:49 AM
 Jaffary Windows 7 32bit Office 2010 32bit Novice Join Date: Feb 2014 Posts: 3

you can do it with
1) VLOOKUP()
2) INDEX() MATCH()

type the below formula in sheet2 cell B2
(suppose in Sheet1, names are mentioned in column A and phone numbers are mentioned in column B)

=IFERROR(VLOOKUP(A2,Sheet1!A:B,2,false),"")

here ...
A2 = is the name on Sheet2, whom phone number u want to search
A:B = is a range on Sheet1, where your data exists
2 = is used to get data from 2nd column of range
False = in your case, it will be.

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post bobsone1 Excel 11 08-07-2014 10:34 PM gbaker Excel 1 08-03-2014 04:01 PM kmorrin Excel 4 06-29-2011 04:38 PM Learner7 Excel 5 06-12-2010 09:54 AM kgfendi Excel 5 05-16-2009 05:42 PM

All times are GMT -7. The time now is 10:38 PM.

 -- Default Style -- Mobile Style Contact Us - Privacy Statement - Top