![]() |
|
#1
|
|||
|
|||
![]()
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 | Thread Starter | Forum | Replies | Last Post |
compare, match and count cell contents between sheets | 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 |