something like:

=index(A1:A99,match(max(b1:b99),b1:b99,0))

Brian Cornejo wrote:

I need to find the max value out of one colume and display the value of the
colume to the left of the max value.
--
Brian

--

Dave Peterson