Information match formula

S

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top