#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! Thank you in advance |
#2
|
||||
|
||||
Hi
an easy way ? I'll let you be the judge of that . See http://www.get-digital-help.com/2009...rom-two-lists/
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#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. |
|
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 |