Using INDIRECT function to refer to named range

[fleathedog]

Hello all

I have a series of named ranges - "July_all" "August_all" etc and have another series of tables that I want to populate using INDEX MATCH formulas (note that the named ranges refer to arrays in a different workbook). As "July" is in cell D5, my thought was that the part of the formula to refer to refer to the array should be:
INDIRECT("D5"&"_all")

But this doesn't work.

When I put just that part of the formula in a separate cell I get a #REF! error. If I use =INDIRECT("D5")&"_all" just by itself in a seperate cell, it returns what I want, but if I use it in the the array part of the lookup formula, I get a #VALUE error.

How can I get the system to combine these 2 strings to use the named range?

Thanks!

 

[Bo_Ry]

try
INDIRECT(D5&"_all")

 

[fleathedog]

Thanks Bo_Ry. I thought I tried that