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?

=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?

Awesome. Thanks!

"David Billigmeier" wrote:

=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?

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?

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.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=501165