Unique Lookup or Different Method 1

[gall3on]

I'm not that familiar with vLookups so my previous attempts failed at using it. I'm not sure this would even work since my 'return' value needs to be a value that happens to be located left of the lookup value.

I have a table with values that correspond to dates.

I wanted to find the max value from a column, let's say in Column C (Submits), but I want a lookup that will return the date where that value showed up. I wanted to do this to show the Extremes in a Dashboard sheet and show the dates for them.

Here's what my Table looks like:

Date Clicks Submits
1/1 5 4
1/2 9 3
1/3 10 5

I want to find the Max under Submits (5), I want to do a lookup that will give me the date for which that value showed up (1/3).

Is there a different way of doing this as well?

 

[bluedragon2]

=INDEX(A:C,MATCH(MAX(C:C),C:C),1)

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[gall3on]

Thanks a bunch! That Index/Match formula worked perfectly!