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