Hello, I have created an excel sheet to do the following:

I want user to pick either Single or Dual (from drop down menu) then enter the Width and Length value.

Then depending on whether it's Single or Dual, I want it to look in the corresponding table and match the Width value of "2" lets say.

Then find the Weight per inch for that Width value of 2 which is 0.7 and multiply by the inputted value for Length which is 5 to give the Weight of 3.5.

How would I go about doing this?

Sheet 1

Type------Width-----Length-----Weight
Single--------2------------5----------x
Dual---------4------------17---------y


Sheet 2

This sheet has 2 separate tables. First table looks like this
S---------i---------n---------g---------l---------e (A1 through C1)
Width--------Weight Per Foot--------Weight Per Inch
2-------------------5----------------------0.7
4-------------------6----------------------0.9
.
.
.
And another table:
D--------------------U-------------A------------L (E1 through G1)
Width--------Weight Per Foot--------Weight Per Inch
2-------------------10----------------------2.4
4-------------------19----------------------9.9