Min and Index Match or Vlookup with multiple criteria

[nyconfidential]

Hi all - I am trying to do either a vlookup or an index match that will find the min value from one column that has a matching value in another column. See below - my goal is to take ALL of the values in Row 2, and search column F for the rows that match, and then return the min value of Column G. So, in this case, I'd want to return the value of "43", since the min Qty of the values listed in Row 2 is 43(RAM-B-238 from Row 2). Can anyone tell me the best way to accomplish this? thanks!

 

[Fluff]

What version of Excel are you using?
Please update your account details to show this, as it affects which functions you can use.

 

[nyconfidential]

What version of Excel are you using?
Please update your account details to show this, as it affects which functions you can use.

Sorry Fluff, its 2016, will update my account shortly

 

[Fluff]

Ok, how about

+Fluff v2.xlsm
	A	B	C	D	E	F	G
1
2	abc	def	hij			xyz	27
3	12	25	19			abc	21
4						mno	17
5						hij	30
6						def	25
7						abc	12
8						def	29
9						xyz	28
10						hij	19
11						abc	30
Master

Cell Formulas
Range	Formula
A3:C3	A3	=AGGREGATE(15,6,$G$2:$G$11/($F$2:$F$11=A2),1)

 

[nyconfidential]

Sorry Fluff, its 2016, will update my account shortly

Ok, how about

+Fluff v2.xlsm
	A	B	C	D	E	F	G
1
2	abc	def	hij			xyz	27
3	12	25	19			abc	21
4						mno	17
5						hij	30
6						def	25
7						abc	12
8						def	29
9						xyz	28
10						hij	19
11						abc	30
Master

Cell Formulas
Range	Formula
A3:C3	A3	=AGGREGATE(15,6,$G$2:$G$11/($F$2:$F$11=A2),1)

Thanks Fluff - I notice that you are searching for one value at a time (explicitly specifying A2 in the formula) - is there a way i can do this by searching for all of the values in row 2 at once (abc, def, hij) and return the min value from row G in one formula?

 

[Fluff]

Ok, how about

=AGGREGATE(15,6,$G$2:$G$11/(($F$2:$F$11=A2)+($F$2:$F$11=B2)+($F$2:$F$11=C2)),1)

You have shown that you also have Excel 365, do you have the Filter function?