Formula for Creating a table using Max Offset and Index Match Function

Please help me create a formula based on a table of finding the nearest lowest exact match as per attached file.

Thank you very much!!!!

Thank you for this. But need to have a formula doing a max offset function and indexmatch. Thank you.
So that if H2 = 25,000 will be a different amount. It can re direct me to a lowest nearest match of the amount.

Thank you very much. It works

Originally Posted by Bo_Ry

Mabye try H3 and copy down

=INDEX(A3:F3,MATCH(MAX(INDEX(((H$2-A$3:F$3)>0)*A$3:F$3,)),A$3:F$3,))