Spreadsheet: 213216d1360385786-match-dates-from-two-cells-mfdtran_l-copy
Sheet: MFDTRAN

Acno | Depo_Amt | Issu_Dt | duration | Int_Rate
11 | 140000 | 2010-06-23 00:00:00 | 36
3985 | 13354 | 2010-05-15 00:00:00 | 36 |  |  |  | I want to fetch interest rates from the ratemas_l sheet
3519 | 1878 | 2010-03-04 00:00:00 | 13 |  | And | TRUE------ | if the issue_dt is between [NAME] and to_dt in th ratemas_l sheet
1349 | 20000 | 2010-05-03 00:00:00 | 5.950684931506849 |  |  | TRUE------ | duration is between fr_month and to_month in ratemas_l sheet
5040 | 48000 | 2010-05-21 00:00:00 | 13 |  |  | fetch int rate----- | than fetch the rate of specfic crteria
1698 | 49900 | 2010-05-21 00:00:00 | 1.512328767123288
1697 | 49900 | 2010-05-21 00:00:00 | 1.512328767123288
5040 | 100000 | 2010-05-21 00:00:00 | 13
4859 | 40000 | 2010-04-15 00:00:00 | 13
1563 | 4445 | 2010-04-02 00:00:00 | 2.991780821917808
5013 | 5000 | 2010-04-15 00:00:00 | 13
78 | 10000 | 2010-04-13 00:00:00 | 36
3540 | 65002 | 2010-04-17 00:00:00 | 25
3541 | 66188 | 2010-04-17 00:00:00 | 25
4496 | 0 | 2010-04-19 00:00:00 | 15
4587 | 27267 | 2010-04-19 00:00:00 | 15
4496 | 49900 | 2010-04-19 00:00:00 | 15
1680 | 24836 | 2010-04-30 00:00:00 | 1.512328767123288
1680 | 25000 | 2010-05-03 00:00:00 | 1.512328767123288
1456 | 18499 | 2010-05-01 00:00:00 | 2.958904109589041
4085 | 49900 | 2010-05-03 00:00:00 | 13
3051 | 6482 | 2010-05-24 00:00:00 | 15
3126 | 13788 | 2010-04-05 00:00:00 | 13
303 | 40000 | 2010-04-05 00:00:00 | 15
1572 | 10268 | 2010-03-26 00:00:00 | 2.991780821917808
1572 | 22329 | 2010-03-26 00:00:00 | 2.991780821917808
1654 | 15296 | 2010-04-04 00:00:00 | 2.958904109589041
3940 | 5245 | 2010-04-19 00:00:00 | 25
4894 | 50000 | 2010-04-17 00:00:00 | 24
4963 | 100000 | 2010-04-19 00:00:00 | 13
4963 | 100000 | 2010-04-19 00:00:00 | 13
5014 | 10000 | 2010-04-19 00:00:00 | 13
3741 | 1000 | 2010-05-05 00:00:00 | 15
5026 | 49900 | 2010-05-05 00:00:00 | 15
4666 | 39369 | 2010-05-02 00:00:00 | 13
4282 | 50000 | 2010-05-15 00:00:00 | 15
4247 | 18733 | 2010-05-07 00:00:00 | 36
4253 | 44057 | 2010-05-12 00:00:00 | 36
142 | 18000 | 2010-06-19 00:00:00 | 15
143 | 15000 | 2010-06-19 00:00:00 | 15
144 | 17000 | 2010-06-19 00:00:00 | 15
5062 | 60000 | 2010-06-18 00:00:00 | 13
1280 | 28942 | 2010-06-06 00:00:00 | 5.950684931506849
1280 | 27153 | 2010-06-06 00:00:00 | 5.950684931506849
4058 | 5726 | 2009-11-13 00:00:00 | 18
4943 | 12500 | 2010-07-08 00:00:00 | 13
1700 | 40353 | 2010-07-20 00:00:00 | 1.512328767123288
303 | 60000 | 2010-04-08 00:00:00 | 15
5017 | 5858 | 2010-04-08 00:00:00 | 13
5017 | 6105 | 2010-04-08 00:00:00 | 13
3126 | 18091 | 2010-04-23 00:00:00 | 13
2159 | 4000 | 2010-01-03 00:00:00 | 13
3814 | 53417 | 2009-11-23 00:00:00 | 13
1689 | 12000 | 2010-04-23 00:00:00 | 8.876712328767123
5019 | 38800 | 2010-04-23 00:00:00 | 36
5020 | 5000 | 2010-04-23 00:00:00 | 36
5021 | 5000 | 2010-04-23 00:00:00 | 36
2993 | 61548 | 2010-04-24 00:00:00 | 13
2992 | 39900 | 2010-04-24 00:00:00 | 13
2667 | 140000 | 2010-04-26 00:00:00 | 13
5022 | 350000 | 2010-04-26 00:00:00 | 13
4752 | 5000 | 2010-04-29 00:00:00 | 36
4069 | 7152 | 2010-04-29 00:00:00 | 25
2322 | 7500 | 2010-04-29 00:00:00 | 13
4746 | 10000 | 2010-05-03 00:00:00 | 13
4956 | 20000 | 2010-05-03 00:00:00 | 13
1426 | 11403 | 2010-06-20 00:00:00 | 5.950684931506849
3879 | 35000 | 2010-06-21 00:00:00 | 15
4294 | 30714 | 2010-06-21 00:00:00 | 13
1416 | 1086 | 2010-06-23 00:00:00 | 1.512328767123288
1416 | 10226 | 2010-06-23 00:00:00 | 1.512328767123288
1416 | 15340 | 2010-06-23 00:00:00 | 1.512328767123288
4656 | 50000 | 2010-06-24 00:00:00 | 15
1512 | 6000 | 2010-06-24 00:00:00 | 5.950684931506849
4580 | 35000 | 2010-06-24 00:00:00 | 18
286 | 30000 | 2010-06-28 00:00:00 | 27
2944 | 33386 | 2010-03-19 00:00:00 | 36
3569 | 5000 | 2010-06-28 00:00:00 | 18
2943 | 33386 | 2010-03-19 00:00:00 | 36
3292 | 1334 | 2010-06-24 00:00:00 | 30
3245 | 19401 | 2010-06-09 00:00:00 | 13
5067 | 5000 | 2010-06-28 00:00:00 | 13
1687 | 20000 | 2010-07-09 00:00:00 | 5.950684931506849
1688 | 15000 | 2010-07-09 00:00:00 | 5.950684931506849
1688 | 20000 | 2010-07-09 00:00:00 | 5.950684931506849
1688 | 20000 | 2010-07-09 00:00:00 | 5.950684931506849
5027 | 22000 | 2010-05-05 00:00:00 | 15
150 | 60000 | 2010-05-05 00:00:00 | 13
2960 | 19002 | 2010-04-16 00:00:00 | 36
4211 | 12489 | 2010-04-01 00:00:00 | 15
4212 | 12489 | 2010-04-01 00:00:00 | 15
4213 | 12489 | 2010-04-01 00:00:00 | 13
4215 | 12489 | 2010-04-02 00:00:00 | 15
4216 | 12489 | 2010-04-02 00:00:00 | 15
4218 | 6244 | 2010-04-02 00:00:00 | 15
4219 | 6244 | 2010-04-02 00:00:00 | 15
175 | 30447 | 2010-03-29 00:00:00 | 15
2121 | 51958 | 2010-04-08 00:00:00 | 15
5026 | 49000 | 2010-05-06 00:00:00 | 24
4214 | 12489 | 2010-04-02 00:00:00 | 15
4210 | 12489 | 2010-04-01 00:00:00 | 15
1349 | 30000 | 2010-05-11 00:00:00 | 5.950684931506849
1692 | 25075 | 2010-05-11 00:00:00 | 0