Dynamically changing the input range of a Drop Down

[DoctorV3774]

I have a drop down in Excel on a sheet named Level 2 Support Team Member. Based on the value of a prior dropdown results for this are in Cell H8 I need the Input Range to change dynamically

Example If H8 =1 the Input range should be Sheet1!$B$2:$B$10
If H8=2 the the Input range should be Sheet1!$c$2:$c$10
And Finally IfH8=3 the the Input range should be Sheet1!$d$2:$d$10

What do I need to do to dynamically change this InputRange? Name of Control is Drop Down 5
Thanks

 

[SkipVought]

Hi

use the OFFSET function in Insert/Name/Define.

The third argument controls the column.

How can I rename a table as it changes size FAQ68-1331

Skip,

_{[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!}

 

[DoctorV3774]

I'm sorry I'm a bit confused. If for example I have the text value of my named range in cell a19, how can I set the InputRange of Drop Down 5 to this named range. If I hard code the named range in the Input range iut picks it up fine but I cannot seem to set it dynamically

 

[SkipVought]

try

=indirect(A9)

Skip,

_{[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!}