Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
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
  #2  
Old 08-12-2015, 11:51 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,146
Pecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nice
Default

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)
Reply With Quote
  #3  
Old 09-12-2015, 02:49 AM
Jaffary Jaffary is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Feb 2014
Posts: 3
Jaffary is on a distinguished road
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
compare, match and count cell contents between sheets bobsone1 Excel 11 08-07-2014 10:34 PM
match two columns of data gbaker Excel 1 08-03-2014 04:01 PM
Compare 4 columns & find dissimilar kmorrin Excel 4 06-29-2011 04:38 PM
How to compare 2 columns with other two columns in EXECL 2007? Learner7 Excel 5 06-12-2010 09:54 AM
Compare data in different columns in an Excel sheet kgfendi Excel 5 05-16-2009 05:42 PM


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


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft