How to lookup and select top 4 data and put with details into another sheet

[afmrubayat]

Hi Good Day!
How to use HLookup by date and combined use of large to find top 5 or N number with related data to another sheet.
or any other solution for following:
I want to retrieve Following Data from Sheet 1 to Sheet 2 based on date to be lookup, with top 20 with respective data.
When another date inserted in cell A1 of sheet 2 date will collect form Sheet 1 and Sheet 2 will be updated.
Sheet 1 will be like this with huge raw data:

[TABLE="******* 983"]
<tbody>[TR]
[TD]
[/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[TD]I
[/TD]
[TD]J
[/TD]
[TD]K
[/TD]
[TD]L
[/TD]
[TD]M
[/TD]
[TD]N
[/TD]
[TD]O
[/TD]
[TD]P
[/TD]
[TD]Q
[/TD]
[TD]R
[/TD]
[TD]S
[/TD]
[TD]T
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]BOID
[/TD]
[TD]BO Short Name
[/TD]
[TD="colspan: 3"]26-Aug-16
[/TD]
[TD="colspan: 3"]27-Aug-16

[/TD]
[TD="colspan: 3"]28-Aug-16

[/TD]
[TD="colspan: 3"]29-Aug-16

[/TD]
[TD="colspan: 3"]30-Aug-16
[/TD]
[TD="colspan: 3"]31-Aug-16
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Credits
[/TD]
[TD]Debits
[/TD]
[TD]Movement
[/TD]
[TD]Credits
[/TD]
[TD]Debits
[/TD]
[TD]Movement
[/TD]
[TD]Credits
[/TD]
[TD]Debits
[/TD]
[TD]Movement
[/TD]
[TD]Credits
[/TD]
[TD]Debits
[/TD]
[TD]Movement
[/TD]
[TD]Credits
[/TD]
[TD]Debits
[/TD]
[TD]Movement
[/TD]
[TD]Credits
[/TD]
[TD]Debits
[/TD]
[TD]Movement
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]1201950000015747
[/TD]
[TD]EBL Securities Limited
[/TD]
[TD]1804
[/TD]
[TD]1800
[/TD]
[TD]649
[/TD]
[TD]100
[/TD]
[TD]0
[/TD]
[TD]100
[/TD]
[TD]200
[/TD]
[TD]2200
[/TD]
[TD]200
[/TD]
[TD]1800
[/TD]
[TD]1000
[/TD]
[TD]1800
[/TD]
[TD]500
[/TD]
[TD]0
[/TD]
[TD]500
[/TD]
[TD]1000
[/TD]
[TD]2100
[/TD]
[TD]1000
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]1205720053777844
[/TD]
[TD]NLI Securities Limited
[/TD]
[TD]0
[/TD]
[TD]4
[/TD]
[TD]0
[/TD]
[TD]2000
[/TD]
[TD]0
[/TD]
[TD]2000
[/TD]
[TD]200
[/TD]
[TD]500
[/TD]
[TD]200
[/TD]
[TD]1000
[/TD]
[TD]0
[/TD]
[TD]1000
[/TD]
[TD]56650
[/TD]
[TD]72650
[/TD]
[TD]2000
[/TD]
[TD]2100
[/TD]
[TD]0
[/TD]
[TD]2100
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]1203490006793073
[/TD]
[TD]Shanta Securities Limited
[/TD]
[TD]1000
[/TD]
[TD]0
[/TD]
[TD]1000
[/TD]
[TD]1600
[/TD]
[TD]19325
[/TD]
[TD]17575
[/TD]
[TD]1000
[/TD]
[TD]0
[/TD]
[TD]1000
[/TD]
[TD]2220
[/TD]
[TD]100
[/TD]
[TD]2220
[/TD]
[TD]1000
[/TD]
[TD]0
[/TD]
[TD]1000
[/TD]
[TD]100
[/TD]
[TD]100
[/TD]
[TD]100
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]1204220018014574
[/TD]
[TD]International Leasing Sec. Ltd
[/TD]
[TD]800
[/TD]
[TD]0
[/TD]
[TD]800
[/TD]
[TD]50
[/TD]
[TD]0
[/TD]
[TD]50
[/TD]
[TD]5000
[/TD]
[TD]0
[/TD]
[TD]5000
[/TD]
[TD]300
[/TD]
[TD]0
[/TD]
[TD]300
[/TD]
[TD]2000
[/TD]
[TD]0
[/TD]
[TD]5000
[/TD]
[TD]200
[/TD]
[TD]0
[/TD]
[TD]100
[/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]1204480020376044
[/TD]
[TD]IIDFC Securities Limited
[/TD]
[TD]100
[/TD]
[TD]0
[/TD]
[TD]100
[/TD]
[TD]500
[/TD]
[TD]0
[/TD]
[TD]300
[/TD]
[TD]5000
[/TD]
[TD]0
[/TD]
[TD]5000
[/TD]
[TD]16000
[/TD]
[TD]63800
[/TD]
[TD]16000
[/TD]
[TD]0
[/TD]
[TD]2050
[/TD]
[TD]10925
[/TD]
[TD]2000
[/TD]
[TD]1540
[/TD]
[TD]3040
[/TD]
[/TR]
[TR]
[TD]8
[/TD]
[TD]1205660050208183
[/TD]
[TD]Trust Bank Securities Limited
[/TD]
[TD]0
[/TD]
[TD]100
[/TD]
[TD]100
[/TD]
[TD]0
[/TD]
[TD]7000
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]20000
[/TD]
[TD]0
[/TD]
[TD]17018
[/TD]
[TD]0
[/TD]
[TD]17018
[/TD]
[TD]2300
[/TD]
[TD]2900
[/TD]
[TD]600
[/TD]
[TD]1000
[/TD]
[TD]0
[/TD]
[TD]500
[/TD]
[/TR]
[TR]
[TD]9
[/TD]
[TD]1204490020697475
[/TD]
[TD]Bank Asia Securities Limited
[/TD]
[TD]0
[/TD]
[TD]398059
[/TD]
[TD]2000
[/TD]
[TD]0
[/TD]
[TD]3975
[/TD]
[TD]0
[/TD]
[TD]3000
[/TD]
[TD]0
[/TD]
[TD]3000
[/TD]
[TD]0
[/TD]
[TD]3000
[/TD]
[TD]0
[/TD]
[TD]2000
[/TD]
[TD]0
[/TD]
[TD]2000
[/TD]
[TD]10925
[/TD]
[TD]0
[/TD]
[TD]10925
[/TD]
[/TR]
[TR]
[TD]10
[/TD]
[TD]1205050043090289
[/TD]
[TD]A. K. Khan Securities Limited
[/TD]
[TD]3802
[/TD]
[TD]302
[/TD]
[TD]18500
[/TD]
[TD]7000
[/TD]
[TD]0
[/TD]
[TD]3000
[/TD]
[TD]1100
[/TD]
[TD]0
[/TD]
[TD]1100
[/TD]
[TD]5400
[/TD]
[TD]11675
[/TD]
[TD]5400
[/TD]
[TD]200
[/TD]
[TD]100
[/TD]
[TD]100
[/TD]
[TD]600
[/TD]
[TD]756
[/TD]
[TD]500
[/TD]
[/TR]
</tbody>[/TABLE]

Sheet 2 will be like this
Based Sheet 1 data cell C1 date to be lookup, with top 3 with respective data in A2:E5

	A	B	C	D	E	F	G	H	I
1			31-Aug-16
2	Sl. No.	BO ID	BO Name		No. of shares
3	1	1204490020697470	Bank Asia Securities Limited		10925
4	2	1205720053777840	NLI Securities Limited		2100
5	3	1204480020376040	IIDFC Securities Limited		2000

<tbody>
</tbody>

Thanks in advance for your kind support.

Regards,
Rubayat

 

[AkaTrouble]

original poster seems to have made double post

i suggest all replies goto other post to save confusion

http://www.mrexcel.com/forum/excel-...op-4-data-put-details-into-another-sheet.html