Try something along these lines:
=INDEX(D1:D7,MATCH(MAX(IF(A1:A70,A1:A7)),A1:A7,0) )
(Array-entered)
Adapt the ranges to suit
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"JAK" wrote in message
...
The array formula MAXIF correctly gives me the maximum
value of A in my table A1:h99, say A43. How can I find
the corresponding value in column D, i.e. in this case D43?
|