Hi
This is my first post - I hope someone can help.
I am trying to use INDEX to search through an array which is itself a dynamic range name, the name for which is entered in a separate cell.
A simple example is attached.
"dynamic" is the name of the range which will vary according to the inputs for "rows" in cell F1 and "columns" in cell F2.
The range name "dynamic" is then entered in a separate cell F3.
The formula I thought would work is shown in cell, which is INDEX(INDIRECT(F3),1,1), which I thought would match R1C1 in the "dynamic" range, but as you can see return a #REF error.
Can anyone see where this is going wrong. The reason for doing it this way is I want to be able to change the value of F3 for different range names and the formula to look in that range name, without having to change the formula itself.
Thanks in anticipation...
Bookmarks