How to conditionally extract cell data from an array

[wdwrkr]

Referring to the attached file, I want to compare the value in A1 to the column values (C1:G1), and use the highest valued column that does not exceed the value in A1 (in this case "30"). Then compare the value in A2 to the row values (B2:B6), and use the highest valued row that does not exceed the value of A2 (in this case "200"). At the intersection of the resultant column (30) and row (200), I want to copy the value to cell A3. In the attached example, I would expect the resultant to be "2".

Thanks very much for any help you can offer.

[JBeaucaire]

Use this in A3:

=INDEX($C$2:$G$6, MATCH($A$2, $B$2:$B$6, 1), MATCH($A$1, $C$1:$G$1, 1))

[wdwrkr]

That's it! Thank you very much.

[JBeaucaire]

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.