Previous Topic Next Topic

Extract data from one sheet to another

Solved/Closed
phanikr
Posts
1
Registration date
Friday June 17, 2016
Status
Member
Last seen
June 17, 2016
 - Jun 17, 2016 at 01:29 PM
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
 - 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.

1 reply

Answer 1 / 1
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
 147
Jun 17, 2016 at 03:07 PM
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.
0