Formula to change move down one cell

[Ross]

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!

 

[Bob I]

Formulas can't change other cells.

 

[Mike H]

Hi,

This will always return the last value entered in Column F

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

Mike

 

[Ross]

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!

 

[Ross]

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

 

[Bob I]

You're welcome.