Query two values to return a value

[TRobert]

I'm trying to query column A and column B with values from column E and column F and return the correct values from column C and column D into column G and column H.

Thx

Book1.xlsx
	A	B	C	D	E	F	G	H
1	plan	grade	min	max	plan2	grade2	min1	max2
2	1	25	100	200	1	35	??	??
3	1	35	200	300	2	45
4	1	45	300	400	4	25
5	1	55	400	500	2	55
6	2	45	300	400	2	75
7	2	55	400	500	3	75
8	2	65	500	600	4	65
9	2	75	600	700	1	55
10	3	55	400	500	1	85
11	3	65	500	600	4	75
12	3	75	600	700	4	75
13	3	85	700	800	3	55
14	4	75	600	700	2	105
15	4	85	700	800	1	85
16	4	95	800	900	1	85
17	4	105	900	1000	4	95
Sheet3

 

[ACCERBYSS]

Hey TRobert could you fill in G and H with the results you expect from the formula, I have guessed but my formulas result in 0 where plan and grade dont match numbers in plan2 and grade2
my assumption is this:
formula for min1: =SUMIFS($C$2:$C$17,$A$2:$A$17,$E2,$B$2:$B$17,$F2)
formula for min2: =SUMIFS($D$2:$D$17,$A$2:$A$17,$E2,$B$2:$B$17,$F2)

hope this helps

 

[TRobert]

I ended up using FILTER to solve my issue. =FILTER(named1, (Named2=cell1)*(Named2=cell2),"")

Thx for the input.
Love this site!!!

 

[TRobert]

Correction

=FILTER(named1, (Named2=cell1)*(Named3=cell2),"")