Hi All~

I have a spreadsheet with a basic =f15 type formula. I need that formula to
change automatically each month to the next cell down-f16, for example-if
there is anything entered in that cell. I would like to do this with a
formula rather than a macro. Any ideas??

Much appreciated & I always leave feedback:-) Thanks!
--
smither fan

Formulas can't change other cells.

Ross wrote:

Hi All~

I have a spreadsheet with a basic =f15 type formula. I need that formula to
change automatically each month to the next cell down-f16, for example-if
there is anything entered in that cell. I would like to do this with a
formula rather than a macro. Any ideas??

Much appreciated & I always leave feedback:-) Thanks!

Hi,

This will always return the last value entered in Column F

=LOOKUP(2,1/(F15:F1000<""),F15:F1000)

Mike

"Ross" wrote:

Hi All~

I have a spreadsheet with a basic =f15 type formula. I need that formula to
change automatically each month to the next cell down-f16, for example-if
there is anything entered in that cell. I would like to do this with a
formula rather than a macro. Any ideas??

Much appreciated & I always leave feedback:-) Thanks!
--
smither fan

Hi Mike
Your right! It did exactly what you said it would. The problem is that I
didn't explain properly. I have other things a number of rows down in the
same column, so I don't want it to necessarily refer to the last cell. I
need a formula that would change the reference down 1 row when I input
something into the cell below the last months input. I guess I'm trying to
figure out a formula that would change the cell reference. Let's say my
formula refers to f15-when I input something into f16 I need the formula to
change to f16. Is this possible?? Probably only code would do this??

Thanks for such prompt attention!
--
smither fan


"Mike H" wrote:

Hi,

This will always return the last value entered in Column F

=LOOKUP(2,1/(F15:F1000<""),F15:F1000)

Mike

"Ross" wrote:

Hi All~

I have a spreadsheet with a basic =f15 type formula. I need that formula to
change automatically each month to the next cell down-f16, for example-if
there is anything entered in that cell. I would like to do this with a
formula rather than a macro. Any ideas??

Much appreciated & I always leave feedback:-) Thanks!
--
smither fan

Thanks Bob for the quick reply! I think you answered my question. No harm
in trying, though....
--
smither fan


"Bob I" wrote:

Formulas can't change other cells.

Ross wrote:

Hi All~

I have a spreadsheet with a basic =f15 type formula. I need that formula to
change automatically each month to the next cell down-f16, for example-if
there is anything entered in that cell. I would like to do this with a
formula rather than a macro. Any ideas??

Much appreciated & I always leave feedback:-) Thanks!

You're welcome.

Ross wrote:

Thanks Bob for the quick reply! I think you answered my question. No harm
in trying, though....