how do I get this

Mutaz · External Since: Nov 19, 2005 Posts: 1

I'm trying to find a function that find the max. value in one column but
return the corrosponding value from a different column though in the same row.

Dave Peterson · External Since: Jul 08, 2005 Posts: 16047

=index(a1:a10,match(max(b1:b10),b1:b10,0))

Mutaz wrote:
>
> I'm trying to find a function that find the max. value in one column but
> return the corrosponding value from a different column though in the same row.

--

Dave Peterson