Data tables in excel 2007

you will have to use a two variable data table.
A two-variable data table uses a formula that contains two lists of input values. The formula must refer to two different input cells.
Arrange your data as follows
A< >B< >C < >E
1 Price1< >A1*A2<> price2< > Price3……
2 Prod1 Prod2
3 Prod3
.
.
.
Lets say u have 10 prod’s and 5 prices G10 will be your last cell
In a cell B2 the worksheet, enter the formula that refers to the two input cells.
In the above example, in which the formula's starting values are entered in cells A1, A2, you type the formula =A1*A2 (this could by any formula of your choice that uses both A1 and A2) in cell B2.
Type one list of input values in the same column, below the formula. Here you need to put Prod1,2, so on in Colum B below B1.
Enter the second variable list in the same row as the formula, to its right. (where u see price1 ,2 etc)
[b]Select B1:G10 [/b]
On the Data tab, in the Data Tools group, click What-If Analysis, and then click Data Table.
In the Row input cell box, enter the reference to the input cell for the input values in the row.
Type cell A2 in the Row input cell box.
In the Column input cell box, enter the reference to the input cell for the input values in the column.
Type A1 in the Column input cell box.

Click OK