Hi Jeff,

I tested the formulas again, and they are working fine for me (I am using

Excel 2007, but I think that it shouldn't matter).

I even extended to Table to contain 10 more rows of Begin and End dates and

percentages, and also varied the Begin and End dates in the Input page, to

make sure that the formulas work; they do work fine.

Also, the "ROW(A1)" parts in the formula don't have to refer to Sheet1

(ROW(A1) just generates the number 1, and is not sheet-specific).

Please try again. I am cutting/pasting the formulas again from my Excel

trial (This time the formulas contain the range A2

18 instead of A2

8

posted earlier to accommodate an extended Table. Change the range

aqppropriately to suit to your worksheet.

=IF(VLOOKUP($B$2,Sheet1!$A$2:$D$18,4)>=VLOOKUP($B$1,Sheet1!$A$2:$D$18,4)+ROW(A1)-1,INDIRECT("Sheet1!$A"&VLOOKUP($B$1,Sheet1!$A$2:$D$18,4)+ROW(A1)-1),"")

=IF(A4="","",VLOOKUP($A4,Sheet1!$A$2:$C$18,2,0))

=IF(A4="","",VLOOKUP($A4,Sheet1!$A$2:$C$18,3,0))

Hope it works this time!

Thanks,

B. R. Ramachandran