How do I set the LOOKUP formulas for this situation:

TABLE 1:
* Column A displays the names of salesmen (10)
* Cells B1:F1 display the names of Products (5)
* In cells B2:F11 are displayed the % of budget achieved by each salesman
for each of the 5 products

TABLE 2:
In a separate table I set up a commission matrix showing the % commission
due for each product according to the % of budget achieved; the names of the
products run across the top, the % achieved vs. budget in column A, and the %
commission payable in the intersecting cells

TABLE 3:
Contains the lookup formulas that calculate how much commission (in $) is
due to each salesman for each product according to the sales results achieved