I have a dataset that i would like to use to lookup but I need to iterate between set values such as 1:03 that falls between 1:00 and 1:05 AFTER my time of concentration is greater than 1 hr. Any help would be greatly appreciated. 

D=0.48Duration of rainfall event (hours)SI=0.02Slope of longest flow path (elevation difference between 10% and 85% of path length, divided by .75L)Tc=00:29Time of concentration (This is the cell that is looked up on the table Column A)*Tc is calculated using equation that assumes grass and aggregate-lined roads and ditches    Recurrence Interval

(Intensity) first lookup value 

=LOOKUP(B19,’Riley County Rainfall Intensity’!A2:A117,’Riley County Rainfall Intensity’!B2:B117)

(Discharge)

(inches/hr)Qt (cfs)2 year2.54 132 5 year3.1926510 year3.7539025 year4.5659850 year4.86698100 year5.89919

Table Referenced

Time2yr5yr10yr25yr50yr100yr00:055.797.268.5310.3711.8513.3800:065.356.717.899.5810.9512.3600:0756.277.378.9510.2311.5500:084.715.96.948.439.6310.8800:094.465.596.577.989.1210.300:104.245.316.257.598.679.7900:114.045.075.967.248.279.3400:123.864.855.76.927.918.9300:133.714.655.476.657.598.5700:143.574.485.266.47.318.2500:153.444.325.086.177.057.9600:163.344.194.935.996.847.7200:173.254.084.795.826.657.5100:183.163.974.675.676.477.3100:193.093.874.555.536.317.1300:203.013.784.445.46.166.9600:212.943.694.345.276.026.800:222.883.614.245.155.896.6500:232.813.534.155.045.766.500:242.753.464.064.945.646.3700:252.73.393.984.845.536.2400:262.643.323.94.745.426.1200:272.593.253.834.655.31600:282.543.193.754.565.215.8900:292.493.133.684.485.125.7800:302.443.073.614.395.025.6800:312.43.023.554.324.945.5800:322.362.973.494.254.865.4900:332.322.923.434.184.785.4100:342.282.873.384.114.715.3200:352.252.823.324.054.635.2400:362.212.783.273.984.565.1600:372.182.733.223.924.495.0900:382.142.693.173.864.425.0100:392.112.653.123.84.364.9400:402.082.613.073.754.34.8700:412.052.573.033.694.234.800:422.022.532.983.644.174.7300:431.992.492.943.594.124.6700:441.962.462.93.544.064.6100:451.932.422.863.4944.5400:461.92.392.823.443.954.4800:471.882.362.783.393.94.4300:481.852.322.743.353.854.3700:491.822.292.73.313.84.3100:501.82.262.673.263.754.2600:511.782.232.633.223.74.2100:521.752.22.63.183.664.1600:531.732.172.573.143.614.1100:541.712.152.533.13.574.0600:551.692.122.53.063.524.0100:561.672.092.473.033.483.9600:571.652.072.442.993.443.9200:581.632.042.412.953.43.8700:591.612.022.382.923.363.8301:001.5922.362.893.323.7801:051.511.892.242.743.163.601:101.441.82.132.613.013.4301:151.371.722.032.52.883.2801:201.311.651.942.392.753.1401:251.261.581.862.292.643.0201:301.211.511.792.22.542.901:351.161.461.722.122.452.7901:401.121.41.662.042.362.6901:451.081.351.61.972.282.601:501.041.311.551.912.22.5201:551.011.271.51.852.132.4402:000.981.231.451.792.072.3702:050.951.191.411.742.012.302:100.921.161.371.691.962.2402:150.91.131.341.651.912.1802:200.871.11.31.61.862.1302:250.851.071.271.561.812.0802:300.831.041.241.531.772.0302:350.811.021.211.491.731.9802:400.7911.181.461.691.9402:450.770.971.151.421.651.902:500.760.951.131.391.621.8602:550.740.931.11.361.581.8203:000.730.911.081.341.551.7803:150.680.861.021.261.461.6803:300.650.810.971.191.391.5903:450.610.770.921.131.321.5204:000.580.740.871.081.261.4404:150.560.70.831.031.21.3804:300.530.670.80.991.151.3204:450.510.650.770.951.11.2705:000.490.620.740.911.061.2205:150.470.60.710.881.021.1705:300.460.580.680.850.981.1305:450.440.560.660.820.951.0906:000.430.540.640.790.921.0506:300.40.510.60.740.860.9907:000.380.480.570.70.810.9307:300.360.450.540.660.770.8808:000.340.430.510.630.730.8408:300.320.410.490.60.70.809:000.310.390.470.570.660.7609:300.30.380.450.550.630.7210:000.290.360.430.530.610.6910:300.270.350.410.510.580.6611:000.260.330.40.490.560.6411:300.250.320.380.470.540.6112:000.250.310.370.450.520.5913:000.230.290.340.420.490.5514:000.220.270.320.40.460.5215:000.210.260.310.370.430.4916:000.190.250.290.350.410.4617:000.190.230.270.340.380.4418:000.180.220.260.320.370.4119:000.170.210.250.30.350.3920:000.160.20.240.290.330.3821:000.160.190.230.280.320.3622:000.150.190.220.270.310.3523:000.140.180.210.260.290.3300:000.140.170.20.250.280.32

​I have a dataset that i would like to use to lookup but I need to iterate between set values such as 1:03 that falls between 1:00 and 1:05 AFTER my time of concentration is greater than 1 hr. Any help would be greatly appreciated.  D=0.48Duration of rainfall event (hours)SI=0.02Slope of longest flow path (elevation difference between 10% and 85% of path length, divided by .75L)Tc=00:29Time of concentration (This is the cell that is looked up on the table Column A)*Tc is calculated using equation that assumes grass and aggregate-lined roads and ditches    Recurrence Interval(Intensity) first lookup value =LOOKUP(B19,’Riley County Rainfall Intensity’!A2:A117,’Riley County Rainfall Intensity’!B2:B117)(Discharge)(inches/hr)Qt (cfs)2 year2.54 132 5 year3.1926510 year3.7539025 year4.5659850 year4.86698100 year5.89919 Table Referenced Time2yr5yr10yr25yr50yr100yr00:055.797.268.5310.3711.8513.3800:065.356.717.899.5810.9512.3600:0756.277.378.9510.2311.5500:084.715.96.948.439.6310.8800:094.465.596.577.989.1210.300:104.245.316.257.598.679.7900:114.045.075.967.248.279.3400:123.864.855.76.927.918.9300:133.714.655.476.657.598.5700:143.574.485.266.47.318.2500:153.444.325.086.177.057.9600:163.344.194.935.996.847.7200:173.254.084.795.826.657.5100:183.163.974.675.676.477.3100:193.093.874.555.536.317.1300:203.013.784.445.46.166.9600:212.943.694.345.276.026.800:222.883.614.245.155.896.6500:232.813.534.155.045.766.500:242.753.464.064.945.646.3700:252.73.393.984.845.536.2400:262.643.323.94.745.426.1200:272.593.253.834.655.31600:282.543.193.754.565.215.8900:292.493.133.684.485.125.7800:302.443.073.614.395.025.6800:312.43.023.554.324.945.5800:322.362.973.494.254.865.4900:332.322.923.434.184.785.4100:342.282.873.384.114.715.3200:352.252.823.324.054.635.2400:362.212.783.273.984.565.1600:372.182.733.223.924.495.0900:382.142.693.173.864.425.0100:392.112.653.123.84.364.9400:402.082.613.073.754.34.8700:412.052.573.033.694.234.800:422.022.532.983.644.174.7300:431.992.492.943.594.124.6700:441.962.462.93.544.064.6100:451.932.422.863.4944.5400:461.92.392.823.443.954.4800:471.882.362.783.393.94.4300:481.852.322.743.353.854.3700:491.822.292.73.313.84.3100:501.82.262.673.263.754.2600:511.782.232.633.223.74.2100:521.752.22.63.183.664.1600:531.732.172.573.143.614.1100:541.712.152.533.13.574.0600:551.692.122.53.063.524.0100:561.672.092.473.033.483.9600:571.652.072.442.993.443.9200:581.632.042.412.953.43.8700:591.612.022.382.923.363.8301:001.5922.362.893.323.7801:051.511.892.242.743.163.601:101.441.82.132.613.013.4301:151.371.722.032.52.883.2801:201.311.651.942.392.753.1401:251.261.581.862.292.643.0201:301.211.511.792.22.542.901:351.161.461.722.122.452.7901:401.121.41.662.042.362.6901:451.081.351.61.972.282.601:501.041.311.551.912.22.5201:551.011.271.51.852.132.4402:000.981.231.451.792.072.3702:050.951.191.411.742.012.302:100.921.161.371.691.962.2402:150.91.131.341.651.912.1802:200.871.11.31.61.862.1302:250.851.071.271.561.812.0802:300.831.041.241.531.772.0302:350.811.021.211.491.731.9802:400.7911.181.461.691.9402:450.770.971.151.421.651.902:500.760.951.131.391.621.8602:550.740.931.11.361.581.8203:000.730.911.081.341.551.7803:150.680.861.021.261.461.6803:300.650.810.971.191.391.5903:450.610.770.921.131.321.5204:000.580.740.871.081.261.4404:150.560.70.831.031.21.3804:300.530.670.80.991.151.3204:450.510.650.770.951.11.2705:000.490.620.740.911.061.2205:150.470.60.710.881.021.1705:300.460.580.680.850.981.1305:450.440.560.660.820.951.0906:000.430.540.640.790.921.0506:300.40.510.60.740.860.9907:000.380.480.570.70.810.9307:300.360.450.540.660.770.8808:000.340.430.510.630.730.8408:300.320.410.490.60.70.809:000.310.390.470.570.660.7609:300.30.380.450.550.630.7210:000.290.360.430.530.610.6910:300.270.350.410.510.580.6611:000.260.330.40.490.560.6411:300.250.320.380.470.540.6112:000.250.310.370.450.520.5913:000.230.290.340.420.490.5514:000.220.270.320.40.460.5215:000.210.260.310.370.430.4916:000.190.250.290.350.410.4617:000.190.230.270.340.380.4418:000.180.220.260.320.370.4119:000.170.210.250.30.350.3920:000.160.20.240.290.330.3821:000.160.190.230.280.320.3622:000.150.190.220.270.310.3523:000.140.180.210.260.290.3300:000.140.170.20.250.280.32  Read More

​