ExcelBanter - Vlookup question

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Vlookup question (https://www.excelbanter.com/excel-programming/323875-vlookup-question.html)

MESTRELLA29[_2_]

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

Bob Phillips[_6_]

Vlookup question

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

MESTRELLA29[_2_]

Vlookup question

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

All times are GMT +1. The time now is 09:24 PM.