Dynamically updating range of cells via dropdown menu

I'm hoping this is a simple question someone might help clear up for me.

I've defined a few cell ranges on a worksheet (in my example I've defined their names as site1, site2, site3, site4, site5). All these ranges are identical in # of columns and rows.

On a separate worksheet, I'm trying to display a single named range, depending on the value in a dropdown menu.

In my example, I have a pulldown menu with the following items: site1, site2, site3, site4, site5 (mirroring the named cell ranges). I'd like to display one of these ranges, depending on which name is selected in the dropdown.

Could anyone please provide any insight? Thank you so much for any help you could offer!

Try this formula in A4:

=OFFSET(INDIRECT($A$2),ROWS($A$1:$A1),COLUMNS($A$1:A$1),1,1)

copied down and across the table..

then go back to A4 and delete the formula to get rid of the 0 there.

Thanks for the offer... you can click the scales button on any one of my posts in this thread and click add... instead of the cookies...


Please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Chance2,

Interesting solution...but you should detail how you get that solution as it not easily decipherable as is.