lockup value
 

I want a formula to give value at column c
if the value in cell a1 is between a value in column a-b

columb A column b column c
0 to 5.000.000 100.000
5.000.001 to 20.000.000 200.000
20.000.001 to 50.000.000 300.000
50.000.001 to 75.000.000 400.000
75.000.001 to 100.000.000 500.000

foe example if a1 = 24.000.000 then cell b1= 300.000

lockup value
 

One way:

Assuming your table starts in row 5:

=VLOOKUP(A1, A5:C9, 3, TRUE)

In article ,
"gus" wrote:

I want a formula to give value at column c
if the value in cell a1 is between a value in column a-b

columb A column b column c
0 to 5.000.000 100.000
5.000.001 to 20.000.000 200.000
20.000.001 to 50.000.000 300.000
50.000.001 to 75.000.000 400.000
75.000.001 to 100.000.000 500.000

foe example if a1 = 24.000.000 then cell b1= 300.000

lockup value
 

you can do this sort of thing with vlookup.

Column A ColumnB
0 100
5,000,001 200
20,000,001 300
50,000,001 400
75,000,001 500

the formula would be:
=vlookup(SOMECELL, $a$1:$b$5,2)

where SOMECELL is replaced with the cell address containing the value you
want to test.

-Brian




gus wrote in message ...
I want a formula to give value at column c
if the value in cell a1 is between a value in column a-b

columb A column b column c
0 to 5.000.000 100.000
5.000.001 to 20.000.000 200.000
20.000.001 to 50.000.000 300.000
50.000.001 to 75.000.000 400.000
75.000.001 to 100.000.000 500.000

foe example if a1 = 24.000.000 then cell b1= 300.000