=INDIRECT("A"&1+MATCH(LARGE(D2:D4,1),D2:D4,0))
will return "A3" (The value in A4)
=INDIRECT("A"&1+MATCH(LARGE(D2:D4,2),D2:D4,0))
will return "A1" (The value in A2)
=INDIRECT("A"&1+MATCH(LARGE(D2:D4,3),D2:D4,0))
will return "A2" (THe value in A3)

"pdberger" wrote:

I would like to find a number in an array, then use the cell address of that
number to pull out more info from that row. Here's an example:

A B C D
1 Part # Cost Use Total (= Cost x Use)
2 A1 $5 100 $500
3 A2 $7.50 10 $ 75
4 A3 $100 8 $800

I would like to find the part number of the highest total use. In this
example, that's part A3. I'd like to search using the =LARGE function, find
the highest values, and use the addresses of those values to find part
numbers and other information on those parts.

Any suggestions?