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.