Need Help improving my worksheet

My original thread is below:
http://www.excelforum.com/showthread...1153373http://

This has been working great, but have come to noticed that if our data is a certain way we get the wrong value for some of our fields.

It seems to always happen when our D/O is dropping (Number getting smaller) then we get a increase in that number we are getting the wrong result back.

For Example:
Data:

Depth D/O
14 5.42
16 0.37
18 0.57

What we are getting as a result:
DO5 RANGE
Depth ft DO ppm
14 5.42
18 0.57


What we need to get as the result:
DO5 RANGE
Depth ft DO ppm
14 5.42
16 0.37


@JeteMC

We need it to pull the next lowest value. Regardless if it goes back up.

Let me know if you have anymore questions.

Thanks in Advance!!