You have a reply to one of your threads in .misc

JAK wrote:

The array formula MAXIF correctly gives me the maximum
value of A in a separate sheet in my table Sheet2!A1:H99, say A43. How can
I find
the corresponding value in column D in A1:H99, i.e. in this case Sheet2!D43?

--

Dave Peterson