Displaying MIN/MAX text name from list

[moe10134]

I am creating a formula that tells me what the MIN/MAX/AVERAGE, etc. is from a range. When I create the MIN formula it comes back with a number. Is there a lookup formula or anything that will pull the name of the person that is associated with that MIN ($3,000)number?

Example: =MIN(B5:B63) returns $3,000.

I'd like to know the name of the record that is associated with $3,000 from the range.

Any suggestions? Thank you kindly! =)

 

[VoG]

Try like this

=INDEX(A5:A63,MATCH(MIN(B5:B63),B5:B63,0))