I have a workbook with 2 sheets. On one sheet I have names and phone numbers and email addresses etc. On the other sheet I have just names. Some will match the first sheet. What I need to do is match them and then return the value in the phone field and the email field in 2 seperate cells.
you can use vlookup or index match
assuming
sheet1 assuming the range is from row 2 to row 1000
A = name
B = phone
C = email
Sheet2
A = name
in B2 put
=vlookup(a2, sheet1!$A$2:$C$1000, 2,false)
copy down
in c2 put
=vlookup(a2, sheet1!$A$2:$C$1000, 3,false)
copy down
you will get
#N/A
where there is no match
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks