Oligo,

First, move A1:A2 down to A2:A3, and then move A3 to B2. Enter your formula in F2 and G2, not
F1:F2.When you reference B1, use $B$1, C1 use $C$1, D1 use $D$1. When you reference A2 and B2, do
not use the $ form.

Enter all the combinations of values from A2:B2 into the cells below A3 top Awhatever, and
B3:BWhatever, then copy the formulas from F2:G2 and copy down to match.

HTH,
Bernie
MS Excel MVP


"Oligo" wrote in message
...
let's say i have this excel calculation.

cell A1 air surface (drop down menu)
cell A2 water surface (drop down menu)

Cell B1,C1,D1 are all input value to calculate my output heat load and
pressure drop.

Cell F1 Heat load=
Cell F2 Pressure drop=

my question is how do i tabulate the set of F1 and F2 results into a table
for different set of A1 and A2 combination provided all the b1,c1,d1 stay
constant.
A1 and A2 are drop down menu containing diff type of surfaces.
if my question is not clear do prompt me. thx