Information match formula
 

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!

Information match formula
 

=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!

Information match formula
 

Hi,

If the first column just contains days, not dates, you task will be more
difficult. You would need to tell us how those days are entered: 1-365 or
1-31,1-28,1-31 or Monday, Tuesday... for everyday starting on the first of
the year?

If they are dates, not days, then with the rainfall in B2:B19 and the dates
in A2:A19 you could use the formula already given you:

=INDEX(A2:A19,MATCH(MAX(B2:B19),B2:B19,))

And then just select the cell with the formula and choose Format, Cells,
Number, Custom and type MMM into the Type line.

or if you range name B2:B19 "I" for inches of rain and choose OFFSET
instead of INDEX:

=OFFSET(A1,MATCH(MAX(I),I,),)

Cheers,
Shane

"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!