Complex "If Formula" I think....

[SemperFi6287]

Alright, I have a huge inspection on Monday and I can't get this Excel program to work.

I need to write a complex "Nested IF" formula.

I am going to attach screen shots to show what is going on, But in Column A, I select my dropdown in cell A2 and choose an option. Lets just use "SS67" for our example. (see attachment titled "DropDown Selection")

When I select "SS67" I would like for cell F2 to automatically fill in the weight in lbs. for that selection.

The weight in lbs (for F2) is coming from a table on a seperate worksheet titled "ALL APPLICABLE EMERGENCY CADS" cell B2 on that table. (see attachment titled "CAD Weight Table")

Now, when this is all finished I need the "Cover Page" to have the total weight from all my worksheets where it reads "Total Net Explosive Weight:" (see attachment titled "Cover Page")

I want to thank you all in advance for your help.

Semper Fidelis
-SemperFi6287-