Need help! Lookup function

[aviraled]

Hello!
I need help regarding my file. I am working on my cheque warehousing file. I have a sheet that contains all of my warehoused cheques.I need to create a file wherein it can give me same dated cheques in one sheet. Can you please give me tips on how to do it. I used vlookup but its tedious and I have to check if its correct every time

 

[mole999]

Have you tried a pivot table, vlookup will only return the first value of date (when looked for on its own)