Information match formula

[scott]

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!

 

[Bob Phillips]

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

 

[Shane Devenshire]

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