Menu
Ask a question Report

Extract data from one sheet to another [Solved/Closed]

Posts
1
Registration date
Friday June 17, 2016
Last seen
June 17, 2016
 - Jun 17, 2016 at 01:29 PM - Latest reply:
Posts
1834
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
 - Jun 17, 2016 at 03:07 PM
Excel Ask a question Report
Hello,
I have two sheets of data with almost same columns but sheet 2 has an extra column. How to match the data of sheet 2 with the data in sheet 1?

Example: Sheet 1: i have columns of name, age, sex, address
Sheet 2: I have all the columns said above but with an extra column of phone numbers.
How do I now match the phone numbers given in sheet two with the names in sheet 1.
See more 

1 reply

Report Respond to Mazzaropi
Posts
1834
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
 Jun 17, 2016 at 03:07 PM
0
Thank you
phanikr, Good afternoon.

The VLOOKUP function is very good for this job.
Put the function in spreadsheet 1 and search the same name on the worksheet 2.
The names don't need to be in the same order.
Capture the worksheet phone number 2 and bring to a spreadsheet 1.

Please, tell us if it worked for you.

If you prefer, save your file at a free site, www.speedyshare.com and put a link to download here.
It's easier to help you.

I hope it helps.
Ask a question