KirnonBhale
New Member
- Joined
- Jul 25, 2019
- Messages
- 11
Hi all,
I hope that this is an easy one for you folks.
I'm trying to return a result with an index formula.
EG. =index(Dynamic_Named_Range,1)
Works fine. However the Dynamic_Named_Range is referenced through a Static_Named_Cell.
I thought a formula like =index(indirect(Static_Named_Cell,1) Where the named cell contains the name of the dynamic range would return an answer but currently I keep getting an error.
<tbody>
</tbody>
I hope that this is an easy one for you folks.
I'm trying to return a result with an index formula.
EG. =index(Dynamic_Named_Range,1)
Works fine. However the Dynamic_Named_Range is referenced through a Static_Named_Cell.
I thought a formula like =index(indirect(Static_Named_Cell,1) Where the named cell contains the name of the dynamic range would return an answer but currently I keep getting an error.
Static Named Cell | Dynamic Named Range 1 - Fruit | Dynamic Named Range 2 - Veg | Formula | Result |
Fruit | Apples | Lettuce | =index(Static_Named_Cell,1) | Apples |
Oranges | Cucumber | |||
Pears | Potatoes | |||
<tbody>
</tbody>