Match and Find Matrix Values with Criteria

They both work great. Must say DaddyLongLegs solve was much easier to implement --- though I hear you should avoid array formulas.

Originally Posted by dreicer_Jarr

....though I hear you should avoid array formulas.....

In this situation I would think that it's the most efficient way

You can alter my suggestion so that it doesn't require CSE, i.e. this version

=MAX(INDEX((B9:C9=C6)*(A10:A16=C5)*(B10:C16<=C4)*B10:C16,0))

[assuming you don't ever expect the result to be a negative number]

....but actually the multiplication in that probably makes it marginally less efficient than using my previous suggestion with IFs