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 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jun 17, 2016 at 03:07 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jun 17, 2016 at 03:07 PM
Related:
- Extract data from one sheet to another
- Transfer data from one excel worksheet to another automatically - Guide
- Google sheet right to left - Guide
- Tmobile data check - Guide
- Little alchemy cheat sheet - Guide
- Mark sheet in excel - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jun 17, 2016 at 03:07 PM
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.
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.
