kumquattie
New Member
- Joined
- Sep 18, 2017
- Messages
- 1
Hello everyone, I tried searching for a solution to this, but couldn't find exactly what I was looking for, so here I am. I have a list of thousands of items (with many duplicates) from different vendors and I need to be able to quickly pull the lowest cost of each item with the associated vendor to do a comparison.
Say this is my list of items:
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I want to be able to populate this table:
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I can use MIN IF to find lowest cost, but I can't figure out how to pull the associated vendor without doing a Vlookup with 2 criteria. Is that my only option? Or is there an easier way to do both? I also tried a pivot table because I can pull the MIN costs per item that way, but once I add the vendors, it just gives me all the costs per vendor per item, I can't figure out how to only pull the minimum value's vendor.
Thanks for the help!
Say this is my list of items:
Item | Cost | Vendor |
Soccer ball | $2.00 | Dicks |
Soccer ball | $3.50 | Sports Authority |
Soccer ball | $2.80 | Modell's |
Soccer ball | $3.00 | Jane's Sporting goods |
Soccer ball | $1.90 | Five Below |
Football | $1.75 | Modell's |
Football | $2.15 | Dicks |
Football | $2.80 | Jane's Sporting goods |
Football | $1.90 | Five Below |
Basketball | $4.50 | Jane's Sporting goods |
Basketball | $4.00 | Five Below |
Basketball | $6.00 | Sports Authority |
Basketball | $3.75 | Walmart |
Basketball | $5.25 | Dicks |
Basketball | $5.00 | Modell's |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I want to be able to populate this table:
Item | Lowest Cost | Associated Vendor |
Soccer ball | ||
Football | ||
Basketball |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I can use MIN IF to find lowest cost, but I can't figure out how to pull the associated vendor without doing a Vlookup with 2 criteria. Is that my only option? Or is there an easier way to do both? I also tried a pivot table because I can pull the MIN costs per item that way, but once I add the vendors, it just gives me all the costs per vendor per item, I can't figure out how to only pull the minimum value's vendor.
Thanks for the help!