Finding the lowest cost for a product from a list

  • Thread starter Thread starter tt
  • Start date Start date
T

tt

I have a list of products with the cost of each (each product appears on the
list multiple times with varying costs). I need to create a formula that will
pull the lowest cost for each product into another existing list which
displays all the products once.

Any help is appreciated.
 
This is an ARRAY formula that must be entered using ctrl+shift+enter. If
same sht, remove sht reference

=MIN(IF(Sheet11!A2:A22=a1,Sheet11!B2:B22))
 
Hi tt,

Since a vlookup will always pull the first instance it finds, sort your list
by the product column (or part number or whatever value you are looking up)
first, then by the price column in the order of smallest to largest. That way
all the items are grouped, the smaller price will be on top, and will be
found first.

Squeaky
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Traspose Column data into Row 3
IF statement pulling from Product List 5
Formulas to Numbers 2
Looking for formula for lowest costs, excluding zero 7
Need to display price in $ or £ dependant on supplier 6
Summary of Unique item values 2
Dynamic Range Defined by Value of Cell 7
Cost Coding? How in the.....? 9

Back
Top