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