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

On Jan 13, 1:07*am, classroomlaw
wrote:
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. *