finding lowest priced item in a list

T

TimH

I have a range (A3:D13) that has item numbers in column A and prices in
column D. I am trying to write a formula that will return the product number
of the lowest priced item in the list. Anyone? Anyone?
 
B

BenjieLop

TimH said:
I have a range (A3:D13) that has item numbers in column A and prices in
column D. I am trying to write a formula that will return the produc
number
of the lowest priced item in the list. Anyone? Anyone?
Click to expand...

To determine the lowest price in Column D, use this formula

=MIN(D3:D13

To return the product number of the lowest priced item in the list

=INDEX(A3:A13,MATCH(MIN(D3:D13),D3:D13,FALSE)

is the formula to use.

Regards
 
Top