Index Function Won't find Array by Array Name?

[sanreb]

Hi There,


I'm spinning my wheels on why the INDEX function in Excel won't allow me to find the array referencing a cell with the array name in it? I am trying to use the plug in and I can't get it to work, so sorry to be posting pictures only. I appreciate your help!

Thanks,

Sandra

 

[Fluff]

Hi & welcome to MrExcel.
How many named ranges do you have?

 

[sanreb]

Hi, thank you for looking at this. I have about 100 different named ranges.

 

[Fluff]

In that case you will need to use Indirect like

=INDEX(INDIRECT(G2),1,1)

or as you have 365 just

=INDIRECT(G2)

and it will spill down & across

 

[sanreb]

That worked!!! Thank you very much! I really appreciate your time and help!

 

[Fluff]

You're welcome & thanks for the feedback.