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