Formula help:
Would it be possible to get a highest of some cells and but instead of
retaining the value get the value of adjacent cell. For example, I
have numbers in cells C1 and C2 I also have Dates in Cell B1 and B2
each date corresponds to a score value. I like get a highest value
=MAX(C1:C2) and place it in C4 also like to get the adjacent date to
the highest value and place it in B3. Can this be done?

A B C
1 3/1/2006
5
2 3/5/2006 4
3
4 Date(Adjacent to highest Formula(highest)