Choose Named Range to use depending on cell value

[Kellis]

Hi all,

Is it possible to enter a named range into a formula depening on value in a cell.

I.e If cell value is January use January named range, if cell value is February use February named range. I have looked at various posts and I am beginning to believe it cannot be done and I need to look at other options.

Any help much appreciated

 

[Haz]

You can use INDIRECT(cell) to refer to named ranges.

 

[Kellis]

You can use INDIRECT(cell) to refer to named ranges.

Thank you. Got it, IO used indirect and vlookup to my named ranges. Worked great.