I have a table which lists costs associated with various projects.

The columns a

June | July | August | ... |December

and the rows are the costs of individual projects over these months.

Our rule is that if JulyCost JuneCost, OK, else go back to project
managers and explain variance.

So, what I would like to do is create some sort of lookup function, in which
I enter today's date, and then Excel compares this month's costs to the
previous month's costs. "IF this month's costs are greater than or equal to
last month's costs, THEN "OK", ELSE "check with project managers" "

Clear?

--
Brevity is the soul of wit.