Moving data from one excel sheet to another using Lookup/Matching
- or -
Post a project like this2303
$
- Posted:
- Proposals: 26
- Remote
- #1828649
- Awarded
AUTOMATION EXPERT l VBA l PYTHON l SQL l POWER AUTOMATE l WINAUTO l DATA ANALYSIS l ACCESS
Greater Noida
Virtual Assistant | Web Research Specialist | Excel | Fillable / Editable PDF |Data Mining Specialist |Data Extraction | & Project Coordinator
Cairo
Live Chat | Customer Service | Email Support | Technical Support | Data Entry | Typing | Virtual Assistant
Cebu City
13940151846556151554216750701768403178829018385701968038196687419640731968460
Description
Experience Level: Entry
Description of excel work: Hi,
We are updating our product information on a spreadsheet, the spreadsheet has three sheets. The first sheet has 15000 SKUS and columns for RRP and IMAGE URL. On sheet 2 and sheet 3 we have all of our current RRP and IMAGE URL information to be put in the columns on SHEET 1. However, we only have this information on SHEET 2 and SHEET 3 for some of the SKUS on SHEET1. We need SHEET 1 to look up this information from SHEET 2 and SHEET 3 and find the correct values for each SKU.
This will then leave us with blanks on SHEET 1 for us to fill in.
Extra notes: Demo sheet attached, the real sheet will contain many more SKUS but will be a simple formula.
We are updating our product information on a spreadsheet, the spreadsheet has three sheets. The first sheet has 15000 SKUS and columns for RRP and IMAGE URL. On sheet 2 and sheet 3 we have all of our current RRP and IMAGE URL information to be put in the columns on SHEET 1. However, we only have this information on SHEET 2 and SHEET 3 for some of the SKUS on SHEET1. We need SHEET 1 to look up this information from SHEET 2 and SHEET 3 and find the correct values for each SKU.
This will then leave us with blanks on SHEET 1 for us to fill in.
Extra notes: Demo sheet attached, the real sheet will contain many more SKUS but will be a simple formula.
Paul B.
100% (28)Projects Completed
25
Freelancers worked with
19
Projects awarded
27%
Last project
25 Mar 2022
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Evening Paul,
Are you looking at getting this done this evening or next week? If next week will an evening be okay?
v/r
Tony
558031
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