Index & match with multiple criteria

[mark91345]

Help! I am trying to get the Volume for a specific stock on a specific date, using Index & Match. The Volume figure I get is completely wrong. I don't know how to fix this.

Date	Symbol	Daily Volume		Symbol	Price
11/18/19	A	100,168		A	79.12​		What is the Daily Volume for
11/19/19	A	142,303		ABC	20.56​		Symbol	ABC
11/20/19	A	132,534		AACAY	6.99​		Date	11/20/19
11/21/19	A	123,815		AAAU	1.88​		Volume
11/22/19	A	134,372
11/01/19	ABC	491,539
11/04/19	ABC	261,774
11/05/19	ABC	294,396					FORMULAS ATTEMPTED:
11/06/19	ABC	184,704					Symbol	6	=MATCH($I$3,$B$2:$B$21,0)
11/07/19	ABC	224,809					Date	3	=MATCH($I$4,$A$2:$A$21,0)
11/18/19	ABC	202,875					Volume	517	{=INDEX($C$2:$C$21,MATCH($I$4,$A$2:$A$21,0)*MATCH($I$3,$B$2:$B$21,0))}
11/19/19	ABC	142,562
11/20/19	ABC	206,502
11/21/19	ABC	169,054
11/22/19	ABC	152,609
11/04/19	AKL	10,304
11/05/19	AKL	39,307
11/06/19	AKL	517
11/18/19	AKL	700
11/22/19	AKL	232

 

[Marcelo Branco]

Try

=INDEX(C$2:C$21,AGGREGATE(15,6,(ROW(C$2:C$21)-ROW(C$2)+1)/((A$2:A$21=I4)*(B$2:B$21=I3)),1))

M.