=TEXT(INDEX(A:A,MATCH(MAX(B:B),B:B,0)),"mmmm")

--
__________________________________
HTH

Bob

"scott" wrote in message
...
I have two columns of data for 2004-2007; one column has days and the other
column has rainfall data for that day. I want to find the month associated
with the largest rainfall instead of sorting the data in
ascending/descending
order. Will VLOOKUP work for this task? I am not familiar with VLOOKUP and
the help in Excel did not offer much guidance.

Thanks!