Formula to enter data of one cell based on greatest amount of anot

  • Thread starter Thread starter classroomlaw
  • Start date Start date
C

classroomlaw

Hello! I am looking for a formula that will search an array for the greatest
number, then enter data from the corresponding cell of a different array.
 
Try this:

=INDEX(D:D,MATCH(MAX(A:A),A:A,0))

assuming you are looking in column A for the largest number and want
the corresponding data returned from column D. If you have multiple
maxima, then this will respond to the first of those.

Hope this helps.

Pete
 
Back
Top