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!