In Progress

EXCEL EXPERT NEEDED

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:

phpthebest

Hi check PM

$40 USD in 0 days
(5 Reviews)
3.2

10 freelancers are bidding on average $46 for this job

bharanisrihari

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

$50 USD in 1 day
(65 Reviews)
6.4
ZeusMan

Looking forward to working with you...

$30 USD in 0 days
(65 Reviews)
5.9
simplicityq88

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

$60 USD in 1 day
(44 Reviews)
4.8
sjestuista

please check pmb for details

$50 USD in 1 day
(3 Reviews)
3.1
ocorah

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)
0.0
picture1985

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

$45 USD in 1 day
(0 Reviews)
0.0
smartlabsolution

Please check pm for details...

$50 USD in 1 day
(0 Reviews)
0.0
dsenthilbe

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)
0.0
ami90s

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

$45 USD in 3 days
(0 Reviews)
0.0
erry

hi sir, give me chance to do this job

$50 USD in 1 day
(0 Reviews)
0.0