I'd think that you should be concerned. If not:

=INDEX(TimeRange,MATCH(MAX(ResultRange),ResultRang e,0))

Jason wrote:
Aladin, is there a way to simplify the equation? I am not concerned about ties.

"Aladin Akyurek" wrote:


See my post in:

http://tinyurl.com/562xz

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!


--

[1] The SumProduct function should implicitly coerce the truth values to
their Excel numeric equivalents.
[2] The lookup functions should have an optional argument for the return
value, defaulting to #N/A in its absence.