Automation for a chart

[hempflengclan]

I need help wth taking a chart that is in paper form and automating the process in excel.

* first column represents max dimension, second column represents
max size range for the first colum.

-Chuck

 

[Luke M]

Array formula in I18
=INDEX(C:C,MIN(IF((MIN(IF($A$4:$A$36>=$F18,ROW($A$4:$A$36)))<=ROW($A$4:$A$36))*($B$4:$B$36>=$G18),ROW($B$4:$B$36))))

Note that array formulas must be confirmed using Ctrl+Shift+Enter, not just enter.
Copy to the right one cell.

 

[hempflengclan]

Thanks Luke, With a few minor changes its now up and running.