I have two drop down lists, one for product and one for feature. Depending on which items are selected, an output cell will display the output of a financial calculation. There are roughly 20 products and four features, so 100 combinations in total.

The problem is I often need to update the financial analysis, which means I will need to manually select each combination of product and feature and copy the result into a separate table.

Is there an automated way to do this? Like write some formula in a cell that forces the drop downs into certain values and returns the output calculation? Then I could drag the formula to fill out the table.