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 | ||||
| ||||||