Hi Gurus

I tried to use INDIRECT to reference a dynamic named range, and discovered you can't do that. I understand the reason why (sort of) from doing some research online. What I didn't discover was an alternative. Is there one? I want to be able to reference a dynamic named range within a formula based on a value in a cell. I don't want to have to type the name of the range each time, or use nested IF's.

I don't have an example sheet to upload at this time, but I'm not an Excel noob, so some advice of things to investigate would be sufficient.

Thanks in advance