Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

LinkBack Thread Tools Display Modes
Old 08-12-2015, 11:37 AM
Neydo222 Neydo222 is offline Mac OS X Office for Mac 2011
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
Old 08-12-2015, 11:51 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,292
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light


an easy way ? I'll let you be the judge of that . See
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.
Reply With Quote
Old 09-12-2015, 02:49 AM
Jaffary Jaffary is offline Windows 7 32bit Office 2010 32bit
Join Date: Feb 2014
Posts: 3
Jaffary is on a distinguished road

you can do it with

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)


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

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:38 PM.

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