picking a matrix cell using drop downs

stuo81

New Member
Hi I am trying to get excel to pick a cell from a hiden matrix and showing it on my worksheet. I want to pick the cell using 2 drop down boxes as bellow - 1 drop down picks option on X axis and the second picks using the Y axis and then the coresponding cell in the matrix is displayedMatrix examplehttp://i1149.photobucket.com/albums/o596/stuolsen81/matixexample_zpsf7de55c2.jpgDrop downs examplehttp://i1149.photobucket.com/albums/o596/stuolsen81/dropdowns_zps240ee048.jpgI am a novice with litytle experience of excel so please if you are kind enough to respond keep it nice and simple for me.Many thanks

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Here's one way, if I understand correctly.

And for reference:
y1 to y5 is C2:C6
x1 to x5 is D1:H1
Where y2 is a value from drop down 1. (cell A1)
Where x4 is a value from drop down 2. (cell B1)
Where you see the value 2 below y2 the cell formula is =MATCH(A1,C2:C6,0)
Where you see the value 4 below 2 the cell formula is =MATCH(B1,D1:H1,0)
Where you see the value q below 4 the cell formula is =INDEX(D2:H6,A2,A3)

Rich (BB code):
``````
y2x4x1x2x3x4x52y1afkpu4y2bglqvqy3chmrwy4dinsxy5ejoty

<colgroup><col style="width: 54pt;" span="8" width="72">
<tbody>

</tbody>``````

Regards,
Howard

Thats fantastic Howard. Thanks so much - I can't believe you understood what I wanted from my post ha. I have spent till now (when I've had chance) sorting it to work with my desired info and Matrix etc.

I know have another issue I need to have a 1st drop down box which depending on what is chosen from that list will affect which matrix (one of two) the second 2 drop downs will choose as you have already explained the cell from the relevant matrix.

The reason I need the 1st drop down to hold a long list of items but only choose from 1 of 2 matrices is that as well as choosing the relevant matrix it also needs to display info from another un related hidden list to be displayed in a specific cell

Again any help form yourself or anyone else would be much appreciated

S

You can send me a workbook example of what you are trying to do and I will take a look at it.

Include concise instructions of what you want to happen.
Where you want it ti happen.
And an example of what the correct results would look like if all the formulas worked as you want them to.

remove the spaces

lh kittle @ com cast . net

Howard

Thanks so much - I'm off work for just over a week now so when I get back in I'll send you a cleaned up mock up with some details thanks again

S

Replies
4
Views
623
Replies
2
Views
875
Replies
5
Views
702
Replies
3
Views
410
Replies
0
Views
291

1,203,269
Messages
6,054,467
Members
444,727
Latest member
Mayank Sharma

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back