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 excel expert, file excel expert, excel sheet expert, xlsx, expert operating, expert excel, excel work today, excel vlookup, calculate different, drop downs, excel inputs, 2011 excel add, excel data update, open expert, excel drop, excel input sheet, products excel sheet, update data accordingly, excel sheet work done, need order excel work, update excel, add product excel sheet, excel data match, excel added today, manually done products

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 project.ty

$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