Google Sheet - VLOOKUP and IMPORTRAGE - EXPERT needed for building some Google Sheets

Good day!

A quick description of the job at hand:

1) we have one Masterfile Google Sheet where all our companies product data is stored
- column a: brand
- column b: product name
- column c: SKU
- column d: color
....

2) we want multiple new Google Sheets per brand that each import data automatically from the Masterfile, dependent on the value in column a brand

3) we want multiple Google Sheet per SKU that each import data automatically from the Masterfile, dependent on the value in column c SKU

These sheets need to continue working if:
- new columns are added in Masterfile
- we use more than one value to lookup (i.e. in 3) where the lookup is based on SKU, we want to be able to import data from the Masterfile in one sheet based on multiple SKUs)
- the value we lookup is not in the first but in the, say, third column

Looking forward to chatting with you and quickly getting to a solution.

Plus, our whole business is organized, we probably have a few more other problems where you could make our live easier.

Your profile:
- expert on Google Sheets
- has build similar Sheets before
- clear communicator
- available on a short notice
- quick turn around

Screening question:
This question simply tests for your attention to detail. When sending your proposal to this job please tell me in the first sentence whats the weather today where you are at. Its blue skies where I am :)

Thanks
About the recuiter
Member since Mar 14, 2020
Mehdy Panah
from Kahramanmaras, Turkey

---

---

Offer to work on this project closes in 110 days!
Are you interested in this Opportunity?

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions