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