How do I get Vlookup to return multiple matches? | ||||
i hv View attachment sample.xlsx | ||||
Symbol | Time | Price | Quantity | |
GREG.W0006`N | 14:59:59 | 2.1 | 1,000 | |
CLPL.W0014`N | 14:59:59 | 3.1 | 902 | |
CLPL.W0014`N | 14:59:59 | 3.1 | 1,000 | |
YORK.N0000`N | 14:59:56 | 17.6 | 1,900 | |
DIAL.N0000`N | 14:59:56 | 9.3 | 1,000 | |
BIL.N0000`N | 14:59:56 | 3.3 | 3,000 | |
MBSL.N0000`N | 14:59:55 | 19.3 | 500 | |
MBSL.N0000`N | 14:59:55 | 19.3 | 200 | |
MBSL.N0000`N | 14:59:55 | 19.3 | 100 | |
MBSL.N0000`N | 14:59:55 | 19.3 | 1,000 | |
I Want lyk this | ||||
time price volume | ||||
MBSL.N0000`N | 14:59:55 | 19.3 | 500 | |
14:59:55 PM | 19.3 | 200 | ||
14:59:55 | 19.3 | 100 | ||
14:59:55 | 19.3 | 1,000 | ||
14:59:55 | 19.3 | 10,000 | ||
14:59:55 | 19.4 | 500 | ||
14:59:55 | 19.4 | 2,000 | ||
14:59:55 | 19.4 | 100 | ||
14:59:55 | 19.4 | 1,500 | ||
14:59:55 | 19.4 | 2,000 | ||