Yes. I tested this and it worked. Note, you probably want to change to
absolute cell referencing. I named a range Nov (also one name Dec) In cell
H16 was the text Nov (and Dec was in the cell below it.) Since I used
relative referencing, when I copied the formula down, it used the Dec range
for the next cell.

=VLOOKUP(I16,INDIRECT(H16),2,FALSE)

"carl" wrote:

I am using this formula:

=VLOOKUP($A506;Nov;2;FALSE)

Is there a way to have the formula refer to cell A5 (Which has the text
value "Nov" in it) instead of explicitly having it in the formula.

Regards.