Modifying VLookUp

C

carl

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.
 
N

Niek Otten

I don't think you have that as a formula, you probably have

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

If so, change your formula to

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

If not, you seem to have a cell with the name Nov and probably the text
"Nov" in it.
Press F5, Fill in Nov
Did it get you to another cell?
 
K

Kleev

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)
 
Top