Multiple match criteria in different columns to return the unique value

[HUPAXE]

Hi,
Can somebody help me with this problem?
Thanks,
Bobby

 

[Eric W]

If your case number is an actual number, try the N2 formula. If it's a text value, try the N3 formula.

Book1 (version 1).xlsb
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1		Case	Var1	Var2	Var3	Var4				Var1	Var2	Var3	Var4	Case
2		1	1.2	100	42	475				1.5	1000	44	500	23
3		2	1.2	100	42	500								23
4		3	1.2	100	42	550
5		4	1.2	100	44	475
6		5	1.2	100	44	500
7		6	1.2	100	44	550
8		7	1.2	1000	42	475
9		8	1.2	1000	42	500
10		9	1.2	1000	42	550
11		10	1.2	1000	44	475
12		11	1.2	1000	44	500
13		12	1.2	1000	44	550
14		13	1.5	100	42	475
15		14	1.5	100	42	500
16		15	1.5	100	42	550
17		16	1.5	100	44	475
18		17	1.5	100	44	500
19		18	1.5	100	44	550
20		19	1.5	1000	42	475
21		20	1.5	1000	42	500
22		21	1.5	1000	42	550
23		22	1.5	1000	44	475
24		23	1.5	1000	44	500
25		24	1.5	1000	44	550
26
Sheet20

Cell Formulas
Range	Formula
N2	N2	=SUMIFS(B:B,C:C,J2,D:D,K2,E:E,L2,F:F,M2)
N3	N3	=INDEX(B:B,AGGREGATE(15,6,ROW(B2:B25)/(C2:C25=J2)/(D2:D25=K2)/(E2:E25=L2)/(F2:F25=M2),1))

 

[HUPAXE]

Wow Eric. Never imagined I'd be able to use the sumifs here. Since all rows are unique this totally works and is quite simple too.
Thank you very much.

-B

 

[Eric W]

Yes, that is a clever, unexpected use of SUMIFS that someone (not me) thought up.

Glad to help! Thanks for the feedback.