Index Function with Multiple Areas

[BriargateExcel]

I am trying to use the areas portion of the Index function to select between two different ranges:
=Index((CarRange,TruckRange),1,,$A$1)
CarRange and TruckRange are defined ranges. They resemble: $B$2:$Z$2 and $C$3:$T$3. They are rows of data of different lengths. In my case, CarRange and TruckRange are also dynamic ranges.
I would like to change the value in $A$1 to select between the two ranges

If the Index function is the wrong approach, what is a better way?

 

[COwen]

What exactly are you trying to do? I do not fully understand...

 

[BriargateExcel]

I have a graph that uses the range comes from the Index function. I want switch between the Car graph and the Truck graph.

 

[COwen]

Ok, What are you using as a switch?

 

[Eric W]

How about something like this:

=INDEX(CHOOSE(A1,CarRange,TruckRange),1)

 

[BriargateExcel]

The Choose function does it. Here's what I have now:
CarOrTruckRange is a defined name containing:
=Choose($A$1,CarRange,TruckRange)
I use the value in $A$1 to switch between two different ranges.
I use CarOrTruckRange as the Legend axis (the Y axis) in a graph. By changing the value in $A$1, I can switch between displaying the Car values (stored in dynamic range CarRange) and Truck values (stored in dynamic range TruckRange).
Thank you, Eric W! With your guidance, I was able to solve my problem!

 

[Eric W]

That's great! Glad we could help! ?