Assuming the maximum value occurs only once, regardless of the condition you
are testing in your IF formula,
=VLOOKUP(<your Maxif formula,$A$1:$D$99,4,0)
On Mon, 21 Feb 2005 15:43:16 -0800, "JAK"
wrote:
The array formula MAXIF correctly gives me the maximum
value of A in my table A1:h:99, say A43. How can I find
the corresponding value in column D, i.e. in this case D43?
|