value in cell to determine which named range used in formula

Hi there

I'm hoping someone can help me out here, I have searched and searched on google for asisatnce and within Excel's own help info but to no avail. Maybe i am using the wrong terminology, who knows!?!?!?

What I want to be able to do is to have a text value in a cell which will be the same as a named range and can be called from a formula in another cell.

For example, I have three named ranges: JAN, FEB and MAR. Instead of having a formula which might read:

=VLOOKUP("bill", JAN, 1, 1)

I would like to have in cell A1 the text value "JAN" so that the formula can read:

=VLOOKUP("bill", A1, 1, 1)

Then I can change which named range is used in the formula but changing the value in cell A1.

When I try to do this, the formula just looks up the value as if cell A1 was the range rather than taking the value from A1 as the named range.

Can anyone help me around this?

Thanks

=VLOOKUP("bill", indirect(A1), 1, 1)

Does that work?

Regards

Dav

Thanks very much, yes, this has helped.