Hi

Assuming your values will be in cells b1:B12
=LOOKUP(99^99,B1:B12)
will give you the last value entered in that range.

--

Regards
Roger Govier

"joec" wrote in message
...
I don't think I was clear:

For example: Jan 50
Feb 49
Mar
Apr

XX (is there a formula that will
return 49 as a value in cell xx? And then return a new value if data added
to
cell next to march?)
joec


"FSt1" wrote:

hi
not sure if i understand you but try this
=month(now())

regards
FSt1

"joec" wrote:

Is there a formula I can use to return the most recent months value.

For exmple I have in col A all 12 months jan to dec. In col B numerical
data. I want to be able to bring the current months number to a
specific cell
that will chg each time the next months data is entered.
--
joec