find min from list based on criteria (DMIN??)

[sophiesmith]

Hi!

I have an export with a list of products and prices. Each unique product has a standard reference code, but there might be different cost prices for each product from each supplier. Is there a function so that I can find 1) the lowest cost price for each reference code and ideally the supplier who sells at it?

I've tried a couple of =(MIN(IF...)) and =DMIN functions but can't get them to produce what I want.

Image attached - any help appreciated!

 

[Fluff]

How about

+Fluff New.xlsm
	A	B	C	D	E	F	G
1
2	1	3	a		1	2	c
3	1	10	b		2	3	a
4	1	2	c		3	1	b
5	2	3	a
6	2	9	b
7	2	5	c
8	3	4	a
9	3	1	b
10	3	7	c
11
Totals

Cell Formulas
Range	Formula
F2:F4	F2	=MIN(IF($A$2:$A$10=E2,$B$2:$B$10))
G2:G4	G2	=INDEX($C$2:$C$10,MATCH(E2&"|"&F2,$A$2:$A$10&"|"&$B$2:$B$10,0))
Press CTRL+SHIFT+ENTER to enter array formulas.