View Single Post
  #1   Report Post  
JAK
 
Posts: n/a
Default Array formula reference (Corrected)

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?