Radio button controls with 2-dimensional lookup

[skydivetom]

Experts:

I need some assistance with radio button controls using a "two-dimensional" lookup. Please find attached two tabs where tab "Original" includes an example of radio button lookups.

However, the 2nd tab "Problem" focuses on what I need to accomplish, such as listed below:

*****************************

Background:
- Similar to the original process, I would like to use radio buttons in order to "drive" a table update.
- Now, in contrast to the original process though, I need a *2D* lookup.

Lookup Data (merely example data for demo purposes):
- I have 3 organizations... Alpha, Bravo, Charlie.
- For demo purposes only, each of the 3 organizations have 3 schedules (M, T, W)
- As you can see, the data in cell ranges (B4:D6), (B9:D11), and (B14:D16) is distinct.

What I want to achieve:
1. From the radio group "Org" I want to select "Alpha" or "Bravo" or "Charlie"
2. From the radio group "Schedule", I want to select "M" or "T" or "W"
3. Based on that two-dimensional selection, I want to display the correct data in cell range G4:J6.
4. Ideally, based on radio group "Org", I also would like to display either "Alpha" or "Bravo" or "Charlie in cell G3.

*****************************

How can steps 1:4 be accomplished?

Thank you in advance,
EEH

[torachan]

Small macro intercepting the state of buttons in 'schedule group'

Please Login or Register  to view this content.

[skydivetom]

torachan - thank you... appreciate your providing me the macro.