What is the right function

B

blonskey

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
 
D

Dave Peterson

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

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