Complex 2 table formula

[JD]

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))))))

 

[Herbert Seidenberg]

Excel 2007
Scariest (and only) formula used:
=INDIRECT(Zone) INDIRECT(Slope)
http://www.mediafire.com/file/gdj2yo3zitz/12_23_09a.xlsx

 

[Ms-Exl-Learner]

The difference between Mr. Herbert Seidenberg solution and the solution
provided by me is that, Mr. Herbert Seidenberg properly restructured the data
but I have retrieved the desired result using the formula without changing
the OP's Data Structure.

 

[Herbert Seidenberg]

Agreed

 

[JD]

I tried both methods and neither have work successfully yet. However, the one
below seems the simplest. Can you walk me through how you created the names
and lists and how the indirect feature works? I think my biggest trouble is
figuring out what to do with both the "Slope" names...and the relationship
between the two indirect's.

Thanks so much for your help.