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

phanikr 1 Posts Friday June 17, 2016Registration date June 17, 2016 Last seen - Jun 17, 2016 at 01:29 PM - Latest reply: Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen
- Jun 17, 2016 at 03:07 PM
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

Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - 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.