hi, I have a table similar to the one below, but much longer. I would like
to lookup to do this. For 500 in column C, the function will look for number
greater than 500 in column A (this case its 569.3) and take the number beside
in column B (this case 86.09) to column D (in D1).
thanks in advance.


A B C D
71.162 5.55 500 86.09
142.325 15.12 100
213.487 25.2 200
284.65 35.88 300
355.813 47.24 400
426.975 59.36 500
498.138 72.31 600
569.3 86.09 700
640.462 100.68 800