I have a worksheet that is making me crazy. Basically its a sales order form
with drop down menus for each set of items based on category. I want the MSRP
field to autofill with the prices when an item is selected and for this I am
using the "if" with nesting. But it only allows me to nest 8 and I need 14.

Any suggestions on other functions I can use to accomplish this?