Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel
Previous Topic Next Topic

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

Report
Posts
1
Registration date
Friday June 17, 2016
Status
Member
Last seen
June 17, 2016
 -
Posts
1927
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
June 17, 2021
 -
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.
Related:

1 reply

Answer 1 / 1
Posts
1927
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
June 17, 2021
 143
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!