Cell A1 has a constant. Cell B1 has a result derived from the rest of the
spreadsheet. How can I generate a table of results somewhere in the sheet,
after changing the contents of cell A1 a number of times.? I would prefer not
to use VBA or a pivot table.

Input (from A1) Result (from B1)
Input 1 Result 1
Input 2 Result 2
Etc .

Does Excel have something equivalent to a Store Function. If I input the
data in A1 and a row number in A2, say. then what I want to do is equivalent
to the following:

STORE(A1) in Col.D, Row (A2) and Store(B1) in Col. E, Row (A2),

where (X) is the contents of cell X.