Option Group State Decision "Nested Ifs" or Other?

[RichKat]

Hello, I have a group of 19 option buttons and the state of the group is linked to a separate cell (J16). Depending on the state of the group (1-19) I would like to choose a value from cells I16 to I34 (with I16 being 1 and I34 being 19) and stick that value in a Named Range.

What function or technique should I use and can you give an example since I am relatively new to this.

Using Office 2007 Professional on Vista Home Premium

 

[mikerickson]

Something like

Range("namedRange").Value = Range("I15").Offset(Range("J16").Value, 0).Value

 

[RichKat]

Hi Mike,

Thanks for the quick answer. How would I make this code auto calculate and stay current? I need to make sure the named range stays current without pushing a button. Is there a function that would do the same thing?

 

[mikerickson]

If you put this in the cell of the NamedRange,

=OFFSET($I$15,$J$16,0)

 

[RichKat]

Wow! I'm stunned!

Such an eloquent solution compared to 19 nested IF's!!!

Thanks Mike! Sorry to bother you with such elementary questions.