Radio Button Output for Cell Selection

[dblcrona]

I have a chart of costing data. I have two sets of radio buttons on each axis of the chart with a button assigned for each respective row or column. The linked cell (which is on a different worksheet) drives a =CHOOSE command that generates either a number or letter that corresponds with the row or column it is in. I would like to somehow combine the output of those two CHOOSE commands so that they drive a formula. For example if the radio button in row 3 and the radio button in column H were both selected I would line my formula to use the value in cell H3. I have attached my spreadsheet as a reference.Packaging Options Concept.xlsx

[ChemistB]

You don't need the "Choose" function.
Using INDEX
=INDEX($C$3:$H$6, 'Source Data'!$C$8, 'Source Data'!$D$8)
Does that work for you?

[dblcrona]

That works great. Can I do the same with the radio button that selects the column and a checkbox that selects the row? When the checkbox is False the value would be zero.

[ChemistB]

I think that gets a little trickier because you can have multiple options.

This seems to work
=INDEX($C$3:$H$6, 'Source Data'!$C$8, 'Source Data'!$D$8)+SUMPRODUCT((COLUMN($C$1:$H$1)-2='Source Data'!$D$8)*$C$9:$H$19*('Source Data'!$F$14:$F$24=TRUE))+SUMPRODUCT((COLUMN($C$1:$H$1)-2='Source Data'!$D$8)*$C$22:$H$31*('Source Data'!$F$27:$F$36=TRUE))

I had to put your TRUE/FALSES into a single column on 'source data'
See attachment

[dblcrona]

Very clever. I came up with a different solution.Packaging Options Concept.xlsx