Spreadsheet: 476868d1472051045-vlookup-for-date-ranges-example1
Sheet: Sheet1

Date | Option 1 | Option 2
2016-06-01 00:00:00 | 0.2394800326689407 | 0.949599914783249
2016-06-02 00:00:00 | 0.413296049101192 | 0.02383839670331267 |  |  | Option 1 |  |  | Option 2
2016-06-03 00:00:00 | 0.4356533901986119 | 0.6709231702366685 |  |  | Date From | Date To |  | Date From | Date To
2016-06-04 00:00:00 | 0.3055338505760217 | 0.7839929605838473 |  |  | 2016-08-10 00:00:00 | 2016-08-24 00:00:00 |  | 2016-08-10 00:00:00 | 2016-08-24 00:00:00
2016-06-05 00:00:00 | 0.6632273655713198 | 0.4461247201260058
2016-06-06 00:00:00 | 0.5429307027765898 | 0.2600707840527297 |  |  | Result |  |  | Result
2016-06-07 00:00:00 | 0.2074578589783863 | 0.9032781297841653
2016-06-08 00:00:00 | 0.07897872252426552 | 0.3574590315651727
2016-06-09 00:00:00 | 0.977319946000541 | 0.9398221817535692
2016-06-10 00:00:00 | 0.4591863930790814 | 0.7497178364709474
2016-06-11 00:00:00 | 0.7774440448483105 | 0.8260386531838608
2016-06-12 00:00:00 | 0.2642163191986989 | 0.09086444579753894
2016-06-13 00:00:00 | 0.7089286776321388 | 0.9903430656930522
2016-06-14 00:00:00 | 0.4276898618413016 | 0.07646311926481675
2016-06-15 00:00:00 | 0.3942434629827203 | 0.4584201237718615
2016-06-16 00:00:00 | 0.9743568492693417 | 0.5278152806514181
2016-06-17 00:00:00 | 0.9211144223171109 | 0.5789575896336042
2016-06-18 00:00:00 | 0.917958463326646 | 0.8711947523001964
2016-06-19 00:00:00 | 0.3513742528743967 | 0.01472742707577857
2016-06-20 00:00:00 | 0.5004117804277618 | 0.9819239161067129
2016-06-21 00:00:00 | 0.9877717349015073 | 0.4185367928901707
2016-06-22 00:00:00 | 0.2997180264933446 | 0.9763032176189479
2016-06-23 00:00:00 | 0.05800501530332347 | 0.9538667749261942
2016-06-24 00:00:00 | 0.8176300577506603 | 0.192263889160753
2016-06-25 00:00:00 | 0.533542922021905 | 0.8666017284913401
2016-06-26 00:00:00 | 0.02610266086640978 | 0.8870858161326968
2016-06-27 00:00:00 | 0.03909423099628062 | 0.6617136472246435
2016-06-28 00:00:00 | 0.3020487035804168 | 0.7466072690907556
2016-06-29 00:00:00 | 0.3435307636042021 | 0.7518879255290898
2016-06-30 00:00:00 | 0.2691675511685648 | 0.05828979224463149
2016-07-01 00:00:00 | 0.4282706666478722 | 0.09880013266500687
2016-07-02 00:00:00 | 0.08005219519241857 | 0.2233664465465119
2016-07-03 00:00:00 | 0.8742524737020214 | 0.1631665513331355
2016-07-04 00:00:00 | 0.2450588724751117 | 0.5902788241014372
2016-07-05 00:00:00 | 0.6548113570451237 | 0.9405269596149087
2016-07-06 00:00:00 | 0.07920241123580363 | 0.6528552518316985
2016-07-07 00:00:00 | 0.7114180002715609 | 0.07216119878092497
2016-07-08 00:00:00 | 0.7857479234741687 | 0.4273410257407035
2016-07-09 00:00:00 | 0.379240710378924 | 0.6301470077098908
2016-07-10 00:00:00 | 0.4449562942127276 | 0.3566523154994846
2016-07-11 00:00:00 | 0.609495259768437 | 0.6823924791691404
2016-07-12 00:00:00 | 0.7244058427406639 | 0.2011579523626973
2016-07-13 00:00:00 | 0.3075043858810912 | 0.3680684194390554
2016-07-14 00:00:00 | 0.7100086766735954 | 0.008166306719894822
2016-07-15 00:00:00 | 0.4612935349950097 | 0.845307343631129
2016-07-16 00:00:00 | 0.02465918961807501 | 0.2184921236541985
2016-07-17 00:00:00 | 0.7940372035579265 | 0.8652309820327444
2016-07-18 00:00:00 | 0.03119192128475157 | 0.472585539131152
2016-07-19 00:00:00 | 0.7971428236583379 | 0.2259502457785444
2016-07-20 00:00:00 | 0.05182874963602002 | 0.09315984108785824
2016-07-21 00:00:00 | 0.7526053859164085 | 0.3313766972520417
2016-07-22 00:00:00 | 0.705319541459315 | 0.1843523884925884
2016-07-23 00:00:00 | 0.5963405878107765 | 0.4146623293674134
2016-07-24 00:00:00 | 0.3937040269811304 | 0.6772348180434992
2016-07-25 00:00:00 | 0.6291440945268102 | 0.9009668810194886
2016-07-26 00:00:00 | 0.4273756111894527 | 0.4275281078579682
2016-07-27 00:00:00 | 0.06518410822772014 | 0.3430571602354476
2016-07-28 00:00:00 | 0.7046863854169417 | 0.07343660401119767
2016-07-29 00:00:00 | 0.6529159404696312 | 0.2147302783866354
2016-07-30 00:00:00 | 0.5473087467935659 | 0.1521600633971203
2016-07-31 00:00:00 | 0.3431274980362483 | 0.4688577256992993
2016-08-01 00:00:00 | 0.5924419045127107 | 0.646039887919181
2016-08-02 00:00:00 | 0.06744743846650902 | 0.3037890712540399
2016-08-03 00:00:00 | 0.8615701861133676 | 0.9252338857395593
2016-08-04 00:00:00 | 0.2565434249509491 | 0.8370968992175677
2016-08-05 00:00:00 | 0.6130882283582442 | 0.04085563053057362
2016-08-06 00:00:00 | 0.4696175461658051 | 0.6425053721015074
2016-08-07 00:00:00 | 0.608571317551547 | 0.6540726655599524
2016-08-08 00:00:00 | 0.06308642435569378 | 0.01636884768337121
2016-08-09 00:00:00 | 0.4342654254824685 | 0.335024807605571
2016-08-10 00:00:00 | 0.4217076427987173 | 0.4689544400418373
2016-08-11 00:00:00 | 0.4438076887063656 | 0.3298282333847044
2016-08-12 00:00:00 | 0.6913567995833793 | 0.8096790578553424
2016-08-13 00:00:00 | 0.1668716138469845 | 0.2267574441902059
2016-08-14 00:00:00 | 0.7866686900010572 | 0.6780727884263905
2016-08-15 00:00:00 | 0.7614331219172294 | 0.4446506272730034
2016-08-16 00:00:00 | 0.1636955185824639 | 0.463193361194348
2016-08-17 00:00:00 | 0.7393483821701939 | 0.05674836836407915
2016-08-18 00:00:00 | 0.4104737784182757 | 0.5141157305262607
2016-08-19 00:00:00 | 0.2794936617164161 | 0.6340531660882369
2016-08-20 00:00:00 | 0.4353236984451155 | 0.5053460718626119
2016-08-21 00:00:00 | 0.9885323918687084 | 0.1581203421781429
2016-08-22 00:00:00 | 0.286362778270554 | 0.8078491813869872
2016-08-23 00:00:00 | 0.3977706705339513 | 0.4431181931000995
2016-08-24 00:00:00 | 0.9074915712483689 | 0.8706051436793308