Get Offset Value From Max Value In Column (Excel 2016)

Question

I have 7 columns of data; the only columns we will be working with are 1 and 7. In column 1 I have a list of names, and in column 7 there is a value corresponding to the name in column 1. I need to get the name from column 1 that corresponds to the maximum value in column 7. Broken down simply; Mike, Bob, and Angie all sell cars; I need to know who has sold the most cars.

Also please note that I use Excel 2016.

I've tried Match, Max, Index, Offset, Address, and several others. The closest I can get to the real value is when I just set the cell equal to the max value. Right now the max value is 26, but when mixed with other formulae it returns a value of 7 which is coincidentally at the very bottom of the list. So using Match it constantly returns Angie when it should return Bob.

Thanks,

Jamie

Answer 1

Figured it out:

=INDEX(Column1, Match(Max(Column7), Column7, 0))

Thanks for the help!