Using your original set up (where you only had the month name, as text, in
column D), try this array-entered formula...

=MAX(IF(D2:D232=TEXT(MONTH(TODAY()-DAY(TODAY())),"mmmm"),H2:H232))

**Commit formula using Ctrl+Shift+Enter, not just Enter by itself

--
Rick (MVP - Excel)


"drose" wrote in message
...
The error i'm getting is (A vlaue used in the formula is the wrong data
type.

{=MAX(IF(MONTH(D2:D232)=MONTH(TODAY())-1,H2:H232))}

d2:d232 is either blank or month ex. January
h2:h232 is either blank or a whole number ex.2, 5, 8, 12
Thanks,
Paul