I have a table with assessment data showing months of development for a client at different assessment times in Cells I2 to I12, with the number of months separating each assessment in Cells C2:C12. I have a range of Cells A14:A77, with values for months of development (1-60). What I want is to look at the first assessment value (Cell I2) and loop through A14-A77 to find the cell with the last value that is less than or equal to I2, place the value from I2 into column B in the cell adjacent to the last value in the A14-A77 range less than or equal to I2, then I want to place the remaining values in the I3-I12 range in column B offset down a number or rows equal to the number of months between assessments (values in C3:C12). I want this automated so that it will not have to be manually completed at each assessment time.

Any suggestions?