Thread
:
Looking up a column value versus another column value
View Single Post
#
2
Jim Thomlinson
Posts: n/a
Assuming your data starts in cell A1...
=OFFSET(A1, MATCH(MAX(B2:B5), B2:B5), 0)
--
HTH...
Jim Thomlinson
"Jason" wrote:
Time Result
0 0
5 300
10 52000
30 100
So that when the "result" is at a max, the coressponding time is retrived.
Thanks!
Reply With Quote