Vlookup question

[Guest]

I have a Formula

Dec (name range) the following table
1 5000 30%
5001 10000 40%
10001 19999 50%

D9 = 10,000
=VLOOKUP(D9,dec,1) this returns the value 5001

I need to update "Dec" to "jan" By change A Cell, how can i do that?

GRACIAS

 

[Bob Phillips]

Assuming Dec (or Jan ) in A1, I think you mean

=VLOOKUP(D9,INDIRECT(A1),1)

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

THANKS, GRACIAS, DANKE,

Assuming Dec (or Jan ) in A1, I think you mean

=VLOOKUP(D9,INDIRECT(A1),1)

--

HTH

RP
(remove nothere from the email address if mailing direct)