Here are my two tables:

Table 1

Column 1 Col 2 Col 3 Col 4 Col 5
Col 6 Col 7
Row 1 Slope Bands (%) R1 RS RE9 RE11
RE15 RE20
Row 2 0 €“ 14 0.5 0.45 0.4 0.4 0.35 0.35
Row 3 15 €“ 29 0.45 0.4 0.35 0.35
0.3 0.3
Row 4 30 €“ 44 0.4 0.35 0.3 0.3
0.25 0.25
Row 5 45 €“ 59 0.35 0.3 0.25 0.25 0.2 0.2
Row 6 60 €“ 99 0.3 0.25 0.2 0.2 0.15
0.15
Row 7 100 + 0 0 0 0 0 0

Table 2
Col 1 Col 2 Col 3
Row 1 ZONE Area Slope
Row 2 R1-1 31.71 <15%
Row 3 R1-1 32.72 15-30%
Row 4 R1-1 63.70 30-45%
Row 5 R1-1 17.29 45-60%
Row 6 RE9-1 6474.83 45-60%
Row 7 RE9-1 19602.34 15-30%
Row 8 RE9-1 4438.14 <15%

What I need to be able to do is to create a formula that multiplies the
value in table 1 in columns 2-7 that corresponds to the slope and the zone
with the lot area in table 2. For instance, I need to find a formula that
will choose to multiply the value in table 1 Row 5, Col 4 with table 2 row,
6, column 3. I want it to know which value to pull from table 1 to multiply
with in table 2 so the zone and slope categories match up....Is this
possible?

What I have done as a workaround is to sort the data by the zone and then
apply formulas that I developed for each zone. i.e.
=IF(slope="<15%",
area*$Q$8,IF(slope="15-30%",Area*$Q$9,IF(slope="30-45%",Area*$Q$11,IF(slope="45-60%",Area*$Q$12,IF(slope="60-100%",Area*$Q$13,IF(slope="100%",Area*$Q$14))))))