finding lowest priced item in a list
=INDEX(A3:A13,MATCH(MIN(D3:D13),D3:D13,0))
--
Regards,
Dave
"TimH" wrote:
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?
|