Index Match Formula

Hi,
Using this formula to locate the lowest number value from a index match function in excel. The formula found the first value in column B Sheet 2; however, its not the lowest value.
How can i insert MIN function to the formula to find the lowest value in the column B sheet 2?
Date range is 1-1-2024 to 12-31-2024

=IFERROR(INDEX(Sheet2!$B$2:$B$13,MATCH(1,INDEX((Sheet2!$D$2:$D$13<>$AF$1)*(Sheet2!$D$2:$D$13<>$AG$1)*(Sheet2!$F$2:$F$13=$D2)*(Sheet2!$I$2:$I$13=$W2),),0)),"No WOA")

Correct number should be 70774 not 92367

Sample File provided:

Thanks, TMS...
How can i insert the filter function into my formula?

A foolish adaptation in your formula

Formula:

Please Login or Register  to view this content.

Since what you want can be achieved by this formula

Formula:

Please Login or Register  to view this content.

DJ, thanks for the update. The formula does not bring up the correct WOA from 2024 based on the date range. Text WOA on your file is dated for 2016, i'm trying to get the 2024 WOA (70774).

As Glenn said in another topic, this error happens because I relied in your formula...

Ok, correction.

Formula:

Please Login or Register  to view this content.

You are right TMS, that is better. Tks!

Both of you are Awesome,,,It did work. Thank you TMS and DJ,,,i appreciate your assistance. Have a great day.

Tks for the feedback, glad to have helped.