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

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.
 
P

Pete_UK

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
 
Top