Help with vlookup, dates, and filling out a table.

Got a problem that I cannot wrap my head around. In the attached file I have a small table. In cell A2 I am manually entering a date. In cell B2 I am entering a percentage. I need a formula to be placed in cells C2 through N2 that will look at the corresponding column header date in C1 through N1. This date will then look at the date in A2. When the date matches I want the formula result to be the percentage in B2. I also want the percentage to result in every subsequent cell.

Hope that makes sense.ExcelForumTest.xlsx

Put this in C2:

=IF($A2<=C$1,$B2,"")

then copy across.

Hope this helps.

Pete

Pete, it worked perfectly. Many thanks.