software

I have a range (A313) 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(D313),D313,0))

--
Regards,
Davequot;TimHquot; wrote:

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

Awesome. Thanks!

quot;David Billigmeierquot; wrote:

gt; =INDEX(A3:A13,MATCH(MIN(D313),D313,0))
gt;
gt; --
gt; Regards,
gt; Dave
gt;
gt;
gt; quot;TimHquot; wrote:
gt;
gt; gt; I have a range (A313) that has item numbers in column A and prices in
gt; gt; column D. I am trying to write a formula that will return the product number
gt; gt; of the lowest priced item in the list. Anyone? Anyone?


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

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

=MIN(D313)

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

=INDEX(A3:A13,MATCH(MIN(D313),D313,FALSE))

is the formula to use.

Regards.--
BenjieLop------------------------------------------------------------------------
BenjieLop's Profile: www.excelforum.com/member.php...oamp;userid=11019
View this thread: www.excelforum.com/showthread...hreadid=501165