PDA

View Full Version : How do I get Vlookup to return multiple matches?



HANOOF
06-04-2013, 05:58 PM
How do I get Vlookup to return multiple matches?
i hv 827

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 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
pls download nd solve thise 827

Admin
06-04-2013, 10:06 PM
Hi,

See possible answers at the bottom of this page.