=MAX(IF(Sheet1!A2:A200="AUG",Sheet1!B2:B200))

this is an array formula, so commit with Ctrl-Shift-Enter not just Enter

--
__________________________________
HTH

Bob

"sajith" wrote in message
...
Month Number
AUG 1
AUG 2
AUG 3
AUG 4
AUG 5
AUG 6
SEP 28
SEP 29
SEP 30
SEP 31
SEP 32
SEP 33

these r the data given in Sheet 1 and i want the highest number in the
month
of august in sheet 2