Using LARGE or MAX inside INDEX-MATCH formula with multiple criteria

I've got an INDEX-MATCH that is working just great, but then I realized that I will most likely have the condition where I have more than one result that is under 100 (see below). So, I'm trying (without success) to incorporate LARGE into the formula in order to get the largest number below 100.

EDIT: At this point, I've reached the end of my Excel rope and completely flabbergasted.
Any help, suggestions, or nudges no matter how small would be greatly appreciated.

Here is the formula that worked great without LARGE:

Formula:

=INDEX(Inventory!A6:I45,MATCH(1,(Inventory!A6:A45=B9)*(Inventory!C6:C45<100),0),9)

This was my last unsuccessful attempt at incorporating LARGE into the formula:

Formula:

=INDEX(Inventory!A6:I50,MATCH(1,(Inventory!A6:A50=B10)*(Inventory!C6:C50<100)*(LARGE(Inventory!C6:C50,1)),0),9)

EDIT: Here is the formula suggested to me using MAX instead of LARGE that worked great in F9, but returns #N/A errors in subsequent cells:

Formula:

=INDEX(Inventory!A6:I13,MATCH(1,(Inventory!A6:A13=B9)*(MAX((Inventory!C6:C13<100)*Inventory!C6:C13)=(Inventory!C6:C13<100)*Inventory!C6:C13),0),9)

EDIT: I've attached a reduced version of the file below.

Here's a quick screen grab:
Formula.jpg