returning data from cell next to MAX value

[Dave76]

Hi-

I have two columns- one with a year, and another with a value for that year. I want to find the max value in the second column, and the corresponding year in the column next to it. Any ideas?

Thanks

[VBA Noob]

Try

Assumes Col is B with max value
=MAX(B:B) in G8

Assumes date in Col A

=INDEX(A:A,MATCH(G8,B:B,0))

VBA Noob

[Dave76]

Works like a charm. Thanks. I don't know how many ways I asked the "Answer Wizard", and never got close to the INDEX and MATCH functions.

[VBA Noob]

No problem

More help here

http://www.contextures.com/xlFunctions03.html

VBA Noob