So I'm trying to create a budget sheet that allows you to input several parameters that dictate what part is being budgeted, and each part has a different formula based on its dimensions.

In other words, for each input row on the item entry sheet, you select parameters "Category" and "Width"(there are only 5 widths) from drop-down menus, then you select "Type" from a drop-down menu and input the length.

The "Types" are divided into "Category"s to streamline the interface.

On another sheet, I have a large matrix of cost formulae (for several different costs for each part of each width). The formulae use the length as an input value.

The layout of this second sheet is

Width 1 Width 2
Cost 1 Cost2 Cost1 Cost2
Cat1Type1
Cat1Type2

Cat2Type1
Cat2Type2

So basically, you input category, width, type and length and it looks up a formula from this table for how to treat widths.

Question1: How can I organize this lookup process so that I don't have a massive nested IF statement?

Question 2: How do I reference the length value in these formulae such that they will use the value from the row that is currently being input? Is it possible to select an arbitrary row number?

I would really appreciate your input