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 |