Returning Smallest/Largest Value of Multiple Matches With Index-Match

[Bluemartini810]

I am working on a pressure loss calc worksheet and need to have an index match formula return the smallest/largest value from the matches.

I have replicated what a typical sheet would look like below.

Each Pressure In cell has the formula
=IFERROR(INDEX(PressureOutList,MATCH(A7,FeedsIntoList,0)),$H$2)

With H2 just being a set pressure value for pipes with an open end
PressureOutList and FeedsIntoList are dynamic ranges that include only the numbers in each of those columns

Unique ID	Pressure In	Pressure Out	Feeds Into
1	100	100.109	2
2	100.109	100.118	3
3	100.118	100.228	4
4	100.228	100.446	8
5	100	100.032	6
6	100.032	100.034	7
7	100.034	100.067	8
8	100.446	100.894	9
9	100.894	101.786

<TBODY>
</TBODY>

I have highlighted the value that is the problem in red.
There are two entries that feed into #8 and I want the formula to return the smallest value in this situation
(In other situations I will need the largest value)
The Value in red should come out to be 100.067 and then the values in orange will automatically update.

Hopefully that is enough information to understand what is going on.

Any help would be much appreciated!