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
[TABLE="width: 500"]
<TBODY>[TR]
[TD]Unique ID
[/TD]
[TD]Pressure In
[/TD]
[TD]Pressure Out
[/TD]
[TD]Feeds Into
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]100
[/TD]
[TD]100.109
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]100.109
[/TD]
[TD]100.118
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]100.118
[/TD]
[TD]100.228
[/TD]
[TD]4
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]100.228
[/TD]
[TD]100.446
[/TD]
[TD]8
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]100
[/TD]
[TD]100.032
[/TD]
[TD]6
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]100.032
[/TD]
[TD]100.034
[/TD]
[TD]7
[/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]100.034
[/TD]
[TD]100.067
[/TD]
[TD]8
[/TD]
[/TR]
[TR]
[TD]8
[/TD]
[TD]100.446
[/TD]
[TD]100.894
[/TD]
[TD]9
[/TD]
[/TR]
[TR]
[TD]9
[/TD]
[TD]100.894
[/TD]
[TD]101.786
[/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]


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!