Multiple content-controlled look-ups

[sockerplaya37]

I need to calculate a term using 3 other content-controlled boxes. # of stories on a house (1, 1.5, 2, 3), how well-shaded (well, normal, exposed), and a climate area (1, 2, 3, 4). I know I'll be nesting statements but am unsure how to join them together without error messages. Table to pull from is below. Semi-new to excel. Thanks!
N-Value Table
# stories
Zone 1 1.5 2 3
1 Well 18.6 16.7 14.9 13
1 Normal 15.5 14 12.4 10.9
1 Exposed 14 12.6 11.2 9.8

2 Well 22.2 20 17.8 15.5
2 Normal 18.5 16.7 14.8 13
2 Exposed 16.7 15 13.3 11.7

3 Well 25.8 23.2 20.6 18.1
3 Normal 21.5 19.4 17.2 15.1
3 Exposed 19.4 17.4 15.5 13.5

4 Well 29.4 26.5 23.5 20.6
4 Normal 24.5 22.1 19.6 17.2
4 Exposed 22.1 19.8 17.6 15.4

[Melvinrobb]

By adding in a helper column, the attached file should work.
Your inputs go in cells B2, C2, and E2; Result appears in F2.

[olasa]

An alternative: =SUMPRODUCT((D10:G10=B4)*(C11:C22=B8),D11:G22)
...just for fun
//Ola

[sockerplaya37]

Both worked! Thanks to you both very much.