In Progress


I prepared an excel sheet where I need your assistance in adding the drop-downs to dynamically update the calculations I am trying to make.

You will need to add (1) drop-down boxes, and properly (2) link it to the input data so that it updates the calculations accordingly (probably via match and vlookup functions).

[url removed, login to view]: this is the main file to work on. Basically, I'd like to have 2 outputs as shown in the tabs.

note: # of Impressions and # of Downloads change depending on which region/operating platform is selected (as well as product).

I separated the input and output to make it simple to know what the variables are. Note that I have 2 types of variables: 1) those that change per product and those that (2) are constant across all the products. I separated this in different tabs as you can see.

[url removed, login to view]: I only added this file to show you how I calculated the ad downloads and impressions manually before, because in the sheet above I left this part open in the variable inputs because I was hoping it can be done quicker than I had done previously (manually). So we must add the downloads/impressions in order for everything to calculate correctly.

I am looking to finish this today! Thanks!

Skills: Excel

See more: looking for excel expert, looking for an excel expert, how to expert in excel, how to be an expert on excel, how to be an expert in excel, how to be an excel expert, how can i expert in excel, file excel expert, excel 0 to expert, how to be expert in excel, excel sheet expert, xlsx, work on excel, Vlookup, expert operating, Expert Excel, excel work today, excel vlookup, excel expert, calculate different, drop downs, excel can open file, excel inputs, 2011 excel add, excel data update

About the Employer:
( 59 reviews ) Dubai, United Arab Emirates

Project ID: #1154270

Awarded to:


Hi check PM

$40 USD in 0 days
(5 Reviews)

10 freelancers are bidding on average $46 for this job


Hello, Excel expert here. Let's start. Please check PM for details. Thanks!

$50 USD in 1 day
(65 Reviews)

Looking forward to working with you...

$30 USD in 0 days
(65 Reviews)

This can be done in 24 hours from now, shall we start?

$60 USD in 1 day
(44 Reviews)

please check pmb for details

$50 USD in 1 day
(3 Reviews)

hello, sir just pm me and maybe i can help u in this [url removed, login to view]

$30 USD in 5 days
(0 Reviews)

>>Here the Expert>>>>>>>>>>>>>>>>>>>lets start now.

$45 USD in 1 day
(0 Reviews)

Please check pm for details...

$50 USD in 1 day
(0 Reviews)

Hi, I can provide you the solution within today. i already sarted to work on this project. Will give you the sample file as soon as possible. Thank you.

$50 USD in 1 day
(0 Reviews)

Hi, I can do it. Please check PM for details.

$45 USD in 3 days
(0 Reviews)

hi sir, give me chance to do this job

$50 USD in 1 day
(0 Reviews)