Modifying VLookUp
 

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.

Modifying VLookUp
 

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?
--
Kind regards,

Niek Otten


"carl" wrote in message
...
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.

Modifying VLookUp
 

Thank you.

"Nov" in the vlookup formula refers to a named table.

"Niek Otten" wrote:

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?
--
Kind regards,

Niek Otten


"carl" wrote in message
...
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.

Modifying VLookUp
 

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.