Help with Lookup(), VLookup
Try this:
=INDEX(A1:A4,MATCH(MAX(B1:B4),B1:B4,0))
Biff
"Phil" wrote in message
...
I have some data in one sheet similar to this:
100.0 2.2
200.0 3.1
300.0 1.9
400.0 2.8
On another sheet, I want to find the maximum value for column 2; i.e. 3.1
(which I can do) and then I want to find the corresponding value in column
1,
i.e. 200.0.
Can someone tell me how to get this?
Thanks,
Phil
|