Hi,
I have been working on an excel table with multiple drop down menus.
Example:
Country Product Industry Sales
a 1
b 2
c 3
d 4
The table above shows an example of my 3 categories and depending on what is chosen for country, product and industry, the output for sales will vary. So users can choose a country, product and industry and then choose between high sales, medium, sales or low sales. These are all drop down menus.
E.g. If I choose Country a, product b and industry c with medium sales, I will get 0.2 as a result.
If I choose country a, product b and industry c with high sales, I will get 0.4 as a result.
I have all individual results in a big table but would like to have them as individual drop downs, kind of like using a converter, so depending on what categories you choose your output will vary.
Country, Product and industry are all independent from each other, but sales output varies with the change of each individual drop down.
I figured out this formula:
=INDEX($J$1:$J$5,MATCH(1,(($F$1:$F$5="UK")*($G$1:$G$5="Xbox 360")*($H$1:$H$5="Automotive")*($I$1:$I$5="High")),0))
This gives me the output for a set combination of criteria, but I would have to use an endless if function to add all individual possibilities in combinations.
Any ideas?
Bookmarks