Try one of these:

=LOOKUP(1E100,B1:B12)

=INDEX(B1:B12,MONTH(NOW()))



--
Biff
Microsoft Excel MVP


"joec" wrote in message
...
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