How to use HLookup by date and combined use of large to find top 5 or N number with related data to another sheet.

[afmrubayat]

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="******* 2080"]
<tbody>[TR]
[TD]BOID
[/TD]
[TD]BO Short Name
[/TD]
[TD="colspan: 3, align: center"] 28-Aug-16
[/TD]
[TD]% Free Float
[/TD]
[TD="colspan: 3, align: center"]29-Aug-16
[/TD]
[TD]% Free Float
[/TD]
[TD="colspan: 3, align: center"]31-Aug-16
[/TD]
[TD]% Free Float
[/TD]
[TD="colspan: 3, align: center"]1-Sep-16
[/TD]
[TD]% Free Float
[/TD]
[/TR]
[TR]
[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]1201950000015747
[/TD]
[TD]EBL Securities Limited
[/TD]
[TD] 1,011,256
[/TD]
[TD] 1,289,035
[/TD]
[TD] (277,779)
[/TD]
[TD]-0.274%
[/TD]
[TD] 1,014,333
[/TD]
[TD] 1,044,463
[/TD]
[TD] (30,130)
[/TD]
[TD]-0.030%
[/TD]
[TD] 651,708
[/TD]
[TD] 764,333
[/TD]
[TD] (112,625)
[/TD]
[TD]-0.111%
[/TD]
[TD] 533,500
[/TD]
[TD] 783,651
[/TD]
[TD] (250,151)
[/TD]
[TD]-0.247%
[/TD]
[/TR]
[TR]
[TD]1205720053777844
[/TD]
[TD]NLI Securities Limited
[/TD]
[TD] -
[/TD]
[TD] -
[/TD]
[TD] -
[/TD]
[TD]0.000%
[/TD]
[TD] -
[/TD]
[TD] 100,000
[/TD]
[TD] (100,000)
[/TD]
[TD]-0.099%
[/TD]
[TD] -
[/TD]
[TD] -
[/TD]
[TD] -
[/TD]
[TD]0.000%
[/TD]
[TD] -
[/TD]
[TD] -
[/TD]
[TD] -
[/TD]
[TD]0.000%
[/TD]
[/TR]
[TR]
[TD]1203490006793073
[/TD]
[TD]Shanta Securities Limited
[/TD]
[TD] -
[/TD]
[TD] -
[/TD]
[TD] -
[/TD]
[TD]0.000%
[/TD]
[TD] 250,000
[/TD]
[TD] 90,000
[/TD]
[TD] 160,000
[/TD]
[TD]0.158%
[/TD]
[TD] 113,600
[/TD]
[TD] 250,000
[/TD]
[TD] (136,400)
[/TD]
[TD]-0.135%
[/TD]
[TD] 56,180
[/TD]
[TD] 19,000
[/TD]
[TD] 37,180
[/TD]
[TD]0.037%
[/TD]
[/TR]
[TR]
[TD]1204220018014574
[/TD]
[TD]International Leasing Sec. Ltd
[/TD]
[TD] -
[/TD]
[TD] -
[/TD]
[TD] -
[/TD]
[TD]0.000%
[/TD]
[TD] 56,967
[/TD]
[TD] 78,767
[/TD]
[TD] (21,800)
[/TD]
[TD]-0.021%
[/TD]
[TD] 14,200
[/TD]
[TD] 67,267
[/TD]
[TD] (53,067)
[/TD]
[TD]-0.052%
[/TD]
[TD] 36,230
[/TD]
[TD] 64,600
[/TD]
[TD] (28,370)
[/TD]
[TD]-0.028%
[/TD]
[/TR]
[TR]
[TD]1204480020376044
[/TD]
[TD]IIDFC Securities Limited
[/TD]
[TD] -
[/TD]
[TD] -
[/TD]
[TD] -
[/TD]
[TD]0.000%
[/TD]
[TD] 700
[/TD]
[TD] 49,805
[/TD]
[TD] (49,105)
[/TD]
[TD]-0.048%
[/TD]
[TD] 35,000
[/TD]
[TD] 25,700
[/TD]
[TD] 9,300
[/TD]
[TD]0.009%
[/TD]
[TD] 14,000
[/TD]
[TD] 14,305
[/TD]
[TD] (305)
[/TD]
[TD]0.000%
[/TD]
[/TR]
[TR]
[TD]1205660050208183
[/TD]
[TD]Trust Bank Securities Limited
[/TD]
[TD] -
[/TD]
[TD] -
[/TD]
[TD] -
[/TD]
[TD]0.000%
[/TD]
[TD] 1,000
[/TD]
[TD] 40,550
[/TD]
[TD] (39,550)
[/TD]
[TD]-0.039%
[/TD]
[TD] 1,000
[/TD]
[TD] 1,000
[/TD]
[TD] -
[/TD]
[TD]0.000%
[/TD]
[TD] -
[/TD]
[TD] 100,000
[/TD]
[TD] (100,000)
[/TD]
[TD]-0.099%
[/TD]
[/TR]
[TR]
[TD]1204490020697475
[/TD]
[TD]Bank Asia Securities Limited
[/TD]
[TD] 20,850
[/TD]
[TD] 9,920
[/TD]
[TD] 10,930
[/TD]
[TD]0.011%
[/TD]
[TD] 30,572
[/TD]
[TD] 47,146
[/TD]
[TD] (16,574)
[/TD]
[TD]-0.016%
[/TD]
[TD] 5,000
[/TD]
[TD] 25,572
[/TD]
[TD] (20,572)
[/TD]
[TD]-0.020%
[/TD]
[TD] 6,345
[/TD]
[TD] 4,035
[/TD]
[TD] 2,310
[/TD]
[TD]0.002%
[/TD]
[/TR]
[TR]
[TD]1205050043090289
[/TD]
[TD]A. K. Khan Securities Limited
[/TD]
[TD] 5,400
[/TD]
[TD] 1,000
[/TD]
[TD] 4,400
[/TD]
[TD]0.004%
[/TD]
[TD] 6,500
[/TD]
[TD] 34,000
[/TD]
[TD] (27,500)
[/TD]
[TD]-0.027%
[/TD]
[TD] -
[/TD]
[TD] 6,500
[/TD]
[TD] (6,500)
[/TD]
[TD]-0.006%
[/TD]
[TD] -
[/TD]
[TD] 1,000
[/TD]
[TD] (1,000)
[/TD]
[TD]-0.001%
[/TD]
[/TR]
[TR]
[TD]1204090016161981
[/TD]
[TD]SJIB SECURITIES LTD.
[/TD]
[TD] 500
[/TD]
[TD] 12,303
[/TD]
[TD] (11,803)
[/TD]
[TD]-0.012%
[/TD]
[TD] -
[/TD]
[TD] 26,085
[/TD]
[TD] (26,085)
[/TD]
[TD]-0.026%
[/TD]
[TD] 4,000
[/TD]
[TD] 2,000
[/TD]
[TD] 2,000
[/TD]
[TD]0.002%
[/TD]
[TD] 5,931
[/TD]
[TD] 5,500
[/TD]
[TD] 431
[/TD]
[TD]0.000%
[/TD]
[/TR]
[TR]
[TD]1201690000001163
[/TD]
[TD]SAR Securities Limited
[/TD]
[TD] 18,300
[/TD]
[TD] 15,000
[/TD]
[TD] 3,300
[/TD]
[TD]0.003%
[/TD]
[TD] 13,050
[/TD]
[TD] 28,861
[/TD]
[TD] (15,811)
[/TD]
[TD]-0.016%
[/TD]
[TD] 15,300
[/TD]
[TD] 5,750
[/TD]
[TD] 9,550
[/TD]
[TD]0.009%
[/TD]
[TD] -
[/TD]
[TD] 10,000
[/TD]
[TD] (10,000)
[/TD]
[TD]-0.010%
[/TD]
[/TR]
[TR]
[TD]1203680008078187
[/TD]
[TD]IDLC SECURITIES LIMITED
[/TD]
[TD] 17,407
[/TD]
[TD] 7,986
[/TD]
[TD] 9,421
[/TD]
[TD]0.009%
[/TD]
[TD] 32,472
[/TD]
[TD] 30,575
[/TD]
[TD] 1,897
[/TD]
[TD]0.002%
[/TD]
[TD] 13,610
[/TD]
[TD] 25,972
[/TD]
[TD] (12,362)
[/TD]
[TD]-0.012%
[/TD]
[TD] 5,720
[/TD]
[TD] 10,300
[/TD]
[TD] (4,580)
[/TD]
[TD]-0.005%
[/TD]
[/TR]
[TR]
[TD]1604620060706290
[/TD]
[TD]SEML LECTURE EQUITY MGMT FUND
[/TD]
[TD] -
[/TD]
[TD] 94,000
[/TD]
[TD] (94,000)
[/TD]
[TD]-0.093%
[/TD]
[TD] -
[/TD]
[TD] 21,354
[/TD]
[TD] (21,354)
[/TD]
[TD]-0.021%
[/TD]
[TD] -
[/TD]
[TD] -
[/TD]
[TD] -
[/TD]
[TD]0.000%
[/TD]
[TD] -
[/TD]
[TD] -
[/TD]
[TD] -
[/TD]
[TD]0.000%
[/TD]
[/TR]
[TR]
[TD]1201520000000854
[/TD]
[TD]Parkway Securities Limited
[/TD]
[TD] 3,802
[/TD]
[TD] 302
[/TD]
[TD] 3,500
[/TD]
[TD]0.003%
[/TD]
[TD] 2,100
[/TD]
[TD] 15,000
[/TD]
[TD] (12,900)
[/TD]
[TD]-0.013%
[/TD]
[TD] 500
[/TD]
[TD] 2,100
[/TD]
[TD] (1,600)
[/TD]
[TD]-0.002%
[/TD]
[TD] 2,300
[/TD]
[TD] 2,900
[/TD]
[TD] (600)
[/TD]
[TD]-0.001%
[/TD]
[/TR]
[TR]
[TD]1205590048601013
[/TD]
[TD]UCB Capital Management Limited
[/TD]
[TD] 29,000
[/TD]
[TD] -
[/TD]
[TD] 29,000
[/TD]
[TD]0.029%
[/TD]
[TD] 1,000
[/TD]
[TD] 13,000
[/TD]
[TD] (12,000)
[/TD]
[TD]-0.012%
[/TD]
[TD] 1,000
[/TD]
[TD] 2,000
[/TD]
[TD] (1,000)
[/TD]
[TD]-0.001%
[/TD]
[TD] 1,000
[/TD]
[TD] -
[/TD]
[TD] 1,000
[/TD]
[TD]0.001%
[/TD]
[/TR]
[TR]
[TD]1203410006442288
[/TD]
[TD]Phoenix Securities Limited
[/TD]
[TD] 4,016
[/TD]
[TD] 916
[/TD]
[TD] 3,100
[/TD]
[TD]0.003%
[/TD]
[TD] 916
[/TD]
[TD] 12,650
[/TD]
[TD] (11,734)
[/TD]
[TD]-0.012%
[/TD]
[TD] 960
[/TD]
[TD] 1,876
[/TD]
[TD] (916)
[/TD]
[TD]-0.001%
[/TD]
[TD] 2,000
[/TD]
[TD] 2,000
[/TD]
[TD] -
[/TD]
[TD]0.000%
[/TD]
[/TR]
[TR]
[TD]1201830000007805
[/TD]
[TD]LANKABANGLA Securities, Dhaka
[/TD]
[TD] 2,924
[/TD]
[TD] 1,590
[/TD]
[TD] 1,334
[/TD]
[TD]0.001%
[/TD]
[TD] 100,810
[/TD]
[TD] 67,249
[/TD]
[TD] 33,561
[/TD]
[TD]0.033%
[/TD]
[TD] 26,000
[/TD]
[TD] 48,310
[/TD]
[TD] (22,310)
[/TD]
[TD]-0.022%
[/TD]
[TD] 31,300
[/TD]
[TD] 45,651
[/TD]
[TD] (14,351)
[/TD]
[TD]-0.014%
[/TD]
[/TR]
</tbody>[/TABLE]



Sheet 2 will be like this
[TABLE="******* 1284"]
<tbody>[TR]
[TD]Thursday, September 01, 2016
[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="******* 545"]
<tbody>[TR]
[TD]
Sl. No.
[/TD]
[TD]BO ID
[/TD]
[TD]BO Name
[/TD]
[TD][/TD]
[TD]No. of shares
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]1601970058396610
[/TD]
[TD]ICB Securities Trading Co.
[/TD]
[TD][/TD]
[TD]1,423,666
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]1201530000003501
[/TD]
[TD]ICB
[/TD]
[TD][/TD]
[TD]1,371,366
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]1201950000015755
[/TD]
[TD]EBL Securities Limited
[/TD]
[TD][/TD]
[TD]660,000
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]1201950043531229
[/TD]
[TD]EBL SECURITIES LTD
[/TD]
[TD][/TD]
[TD]660,000
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]1201950000015747
[/TD]
[TD]EBL Securities Limited
[/TD]
[TD][/TD]
[TD]533,500
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]1201820000005723
[/TD]
[TD]BRAC EPL Stock Brokerage Ltd.
[/TD]
[TD][/TD]
[TD]308,608
[/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]1601670058396616
[/TD]
[TD]NTC A/C DRIEHAUS FEMF
[/TD]
[TD][/TD]
[TD]219,261
[/TD]
[/TR]
</tbody>[/TABLE]


Please help ASAP.

Regards,
Rubayat