Help: Seting the value of another cell with a formula

[Dab]

I know that there's a way to make a cell a particular value based on the
entries of a range, or array of cells, but is it possible to do the reverse,
using only one formula in a cell.

Here's what I'm trying to do:

What I would like to do is set one of a range of cell to have a value based
on the value in A2.
Example: Cell A1 has a value of 2, A2 has a value of 2007. I want A10 to
equal A1, i.e.:2
Cell A1 has a value of 2, A2 has a value of 2008. I want
A11 to equal A1, i.e.:2
Cell A1 has a value of 2, A2 has a value of 2009. I want
A12 to equal A1, i.e.:2

I know that this can be done by filling a range of cells with the proper
formulas, but what I'm looking for is a formula that will set the value of a
third cell, based on the value of some other cell. Something like

If I try: =IF(E9=0,"",E15=E9), but his simply returns a value of "False", It
doesn't set the value of E15 to the value of E9 which is what I want.

Let me know if you have any suggestions. Thanks.

 

[Earl Kiosterud]

Dab,

The model of a spreadsheet is that a cell contains a value (text or number)
or a formula that returns a value. A cell can't change another cell. Only
a macro can. Or you.

In your example, you seem to want A10 to be what's in A1 when A2 is 2007,
2008 or 2009. Putting =A1 in A10 will do that. But I don't think that's
what you want.

 

[Earl Kiosterud]

Dab,

I meant to say "you seem to want A10 to be what's in A1 regardless of what's
in A2." The formula will do that.