Extract data from one sheet to another [Solved/Closed]
phanikr1
Posts Friday June 17, 2016Registration date
June 17, 2016
Last seen
-
Jun 17, 2016 at 01:29 PM - Latest reply: Mazzaropi1826
Posts Monday August 16, 2010Registration dateContributorStatus
April 15, 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.
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.
