Vlookup question

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

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)


"MESTRELLA29" <MESTRELLA29@discussions.microsoft.com> wrote in message
news:0C8E480D-A915-4B6E-A6BF-E8AF2217300A@microsoft.com...
> 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
>

THANKS, GRACIAS, DANKE,

"Bob Phillips" wrote:

> 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)
>
>
> "MESTRELLA29" <MESTRELLA29@discussions.microsoft.com> wrote in message
> news:0C8E480D-A915-4B6E-A6BF-E8AF2217300A@microsoft.com...
> > 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
> >
>
>
>