Help with Index Match

[Ben AFF]

Hi, please appreciate if you can help me. Im trying to do a index match with 3 criteria, 2 vertical and 1 horizontal but the formulas Im trying are not working.

The 2 vertical criteria are normal ones but the the horizontal criteria is weight breaks, >30,>60,>90,>120 so for example if weight is 70, the corresponding weight break is >60.

Im trying this formula with different variations but I cannot make it work.
=INDEX(C4:F7,MATCH(B9,A4:A7,0),MATCH(B10,B4:B7,0),MATCH(B11,C3:F3,-1))

Please is there any way to do a index/match formula to return the correct value as per screenshot attached?

Thank you.

 

[Fluff]

How about

=XLOOKUP(B11,C3:F3,FILTER(C4:F7,(A4:A7=B9)*(B4:B7=B10)),,-1)

 

[Ben AFF]

How about

=XLOOKUP(B11,C3:F3,FILTER(C4:F7,(A4:A7=B9)*(B4:B7=B10)),,-1)

Hi Fluff, thank you so much this worked like a charm. Totally amazing.

 

[Fluff]

You're welcome & thanks for the feedback.