moe10134
Board Regular
- Joined
- Sep 8, 2005
- Messages
- 162
- Office Version
- 2019
- Platform
- Windows
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! =)
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! =)