The table below is a mock of a crane capacity sheet I am trying to manipulate. I have a spreadsheet that determines the capacity given an entered radius (leftmost column) and boom length (uppermost row) by using a vlookup/match formula and that works great. The problem is I want the formula to return a non blank value by searching down the matched list until it comes to a value. For example, the user would enter in a boom length of 90 and radius of 18. Right now the formula would return "N/A" when I want it to return 25000 and adjust the radius to 22 and inform the user of this adjustment. Any help would be greatly appreciated, thanks!

Boom | |||||

Radius | 70 | 80 | 90 | 100 | 120 |

16 | 225000 | ||||

18 | 215000 | 200000 | |||

20 | 210000 | 185000 | |||

22 | 205000 | 165000 | 25000 | 25000 | 25000 |

<tbody>

</tbody>