What is the right function
 

Hello I have a problem I have to get the name of a Part that have the
lowest price in a COL

I have to colums one with name of parts and the other with prices

and i want to get the name of the lowest price part

what function do i have to use??

10x in advance

What is the right function
 

=index(a:a,match(min(b:b),b:b,0))

is one way to get the first part number with the smallest price.

wrote:

Hello I have a problem I have to get the name of a Part that have the
lowest price in a COL

I have to colums one with name of parts and the other with prices

and i want to get the name of the lowest price part

what function do i have to use??

10x in advance

--

Dave Peterson