Transferring data from 1 Excel spreadsheet to another using Vlookup or similar
- or -
Post a project like this4236
£20/hr(approx. $25/hr)
- Posted:
- Proposals: 10
- Remote
- #170037
- Awarded
Description
Experience Level: Intermediate
I'm looking for someone who can help transfer data from one Amazon Inventory spreadsheet to another.
I have attached the spreadsheets to this post for you to have a look at.
What I need doing is -
The 'UK price' column of the 'amazon de matching.xls' spreadsheet needs filling in with the relevant values from the 'price' column of the 'amazon.co.uk inventory.xls' spreadsheet.
Each item in the inventory has a unique 'product-id' these are the same in each spreadsheet, but the 'amazon.co.uk inventory.xls' spreadsheet includes many more than the 'amazon de matching.xls' spreadsheet.
Basically I need someone who can pick all the prices from the 'product-ids' in the 'amazon.co.uk inventory.xls' spreadsheet and enter them into the corresponding 'product-ids' 'UK price' column of the 'amazon de matching.xls' spreadsheet.
I've been told that this can be done using a feature called Vlookup. But I am a complete excel novice so am not sure how to do this!
I hope all of that made sense.
If my description was unclear in anyway please don't hesitate to get in touch and I will try and explain the job again!
Thanks
Laurie
I have attached the spreadsheets to this post for you to have a look at.
What I need doing is -
The 'UK price' column of the 'amazon de matching.xls' spreadsheet needs filling in with the relevant values from the 'price' column of the 'amazon.co.uk inventory.xls' spreadsheet.
Each item in the inventory has a unique 'product-id' these are the same in each spreadsheet, but the 'amazon.co.uk inventory.xls' spreadsheet includes many more than the 'amazon de matching.xls' spreadsheet.
Basically I need someone who can pick all the prices from the 'product-ids' in the 'amazon.co.uk inventory.xls' spreadsheet and enter them into the corresponding 'product-ids' 'UK price' column of the 'amazon de matching.xls' spreadsheet.
I've been told that this can be done using a feature called Vlookup. But I am a complete excel novice so am not sure how to do this!
I hope all of that made sense.
If my description was unclear in anyway please don't hesitate to get in touch and I will try and explain the job again!
Thanks
Laurie
Penloe L.
100% (1)Projects Completed
2
Freelancers worked with
2
Projects awarded
50%
Last project
18 Sep 2012
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies