How do I get Vlookup to return multiple matches?

hanoof

New member
Joined
Jun 4, 2013
Messages
2
Reaction score
0
Points
0
How do I get Vlookup to return multiple matches?
i hv View attachment sample.xlsx
SymbolTimePriceQuantity
GREG.W0006`N
14:59:592.11,000
CLPL.W0014`N
14:59:593.1902
CLPL.W0014`N14:59:593.11,000
YORK.N0000`N14:59:5617.61,900
DIAL.N0000`N14:59:569.31,000
BIL.N0000`N14:59:563.33,000
MBSL.N0000`N14:59:5519.3500
MBSL.N0000`N14:59:5519.3200
MBSL.N0000`N14:59:5519.3100
MBSL.N0000`N14:59:5519.31,000
I Want lyk this
time price volume
MBSL.N0000`N14:59:5519.3500
14:59:55 PM19.3200
14:59:5519.3100
14:59:55 19.31,000
14:59:5519.310,000
14:59:5519.4500
14:59:5519.42,000
14:59:5519.4100
14:59:5519.41,500
14:59:5519.42,000
pls solve this wrk sheet View attachment sample.xlsx
 
The usual solution is to use a concatenation formula. Don't, excel runs out of memory. Go to your data sheet and add a new column. Set this to join your fields, e.g. =A1 & B1. Then in you lookup do =vlookup(date & time, datarange,column,false)
 
Back
Top