Assuming your month names are in the range A1:A12 and are in sequential
order. B1:B12 are numeric values.

=INDEX(B1:B12,MONTH(TODAY()),0)

--
Biff
Microsoft Excel MVP


"Christopher Leigh Stout"
wrote in message ...
I have a column with the months Jan-Dec. In the next column I have a
corresponding monetary value. I want the monetary value for the current
month to automatically be shown in the cell and for it to update as the
year
goes on. I know that I have to recalculate the workbook every day, but
still, how do I make this work?