I have three columns of data

Column A Column B Column C
247,156 247,156 .40
0 247,156 .40
0 247,156 .40
245,156 494,312 .70
247,156 741,468 .30

Column B is a running total of column A.

I need to extract the value from column C based on where a value falls
within the ranges identified in column B.

For example, if the criteria value is 500,000, I would want to extract .70.
If the criteria value is 230,000, I would want to extract .40. If the
criteria value is 750,000, I would want to extract .30.

Is the following formula the best way to get this data:

Hlookup(large(b1:b5,countif(b1:b5,""&d1)+1),b1:c5 ,2,false)

Will I have a problem with this formula since column B has 3 values that are
equal?

Thanks