Help with complex formula

Hi. I'm in some need of help with some formulas that I've pretty much given up on and I was hoping for some suggestions. Attached are two screenshots of two sheets in a spreadsheet I'm working on; I need a formula to compile the data from Attachment B into the table in row 17 in Attachment A.

The example in Attachment A is a Pokemon with two types, Fire and Steel shown in cells C9 and D9. Each type has it's own defensive resistances and offensive strengths against other types, this is summed up in Attachment B using a range from 0 - 2, though this table does only show single type match-ups, a Pokemon with two types' resistance is determined by multiplying the defensive values against a single attacking type, for example the figure in N17 of Attachment A should show 4 as Ground has an effectiveness of 2 against both Fire and Steel as seen in cells D11 and S11 of Attachment 2.

What I want to create a formula to do is essentially take the reference values of cells C9 and D9 in Attachment A and select the corresponding columns in Attachment B, take the reference values from cells D16 to X16 and select the corresponding row in Attachment B, and multiply the two values together. I have over 100 of these to do so a formula to calculate these figures would be much appreciated. Any suggestions?
Much appreciated.