Return multiple values (matrice) by selection of multiple criteria.

Hi there,

Hopefully someone can help me with my problem. I want to with the help of selections (n number of drop down lists) define a criteria (i.e. find a special row) and return a set of values in that row. The drop down list part i know how, its just for explanatory reasons. As shown by example: (I apologize for the spacing, didnt know how).

ListA Model 1
ListB Config 3
ListC ONE

A B C 0% 20% 40% 60% 80% 100%
Model 1 Config 1 ONE 1 2 4 8 16 32
Model 1 Config 2 ONE 1 3 6 12 24 48
Model 1 Config 3 ONE 1 2 6 18 52 156
Model 2 Config 1 TWO 0 1 2 3 4 5
Model 2 Config 2 ONE 0 5 10 15 20 25
Model 2 Config 3 ONE 0 3 6 9 12 15


Desired return value: 1 2 6 18 52 156

or 1
2
6
18
52
156
which ever


Excel version: MS Office Pro Plus 2010

Hope someone can provide me with a solution.

BR

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

In cell E14, enter:

Formula:

Please Login or Register  to view this content.

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

Copy across E14:J14

International settings - in UK, we use a comma as an argument separator. In most of Europe, you use the semi-colon.

Glad you got it working. If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. You can also 'Add Reputation' to those who helped you. Thanks.