Identify start month and repeat the same value in the next 12 cells

Dear Friends,

I am working on a formula by it is repeatedly failing. Please help.

Based on input 1 which is the month name, I am looking for a formula to identify the position across columns as the starting cell and then the value in input 2 needs to be repeated 12 times from there.

Example:
Input 1 is Apr-14
Input 2 is 51.8

I have columns with month names starting Apr-13 to Mar-15

Since the input 1 is Apr-14, the formula should identify the appropriate column named as Apr-14 and from there it should copy the value (input 2 ) 51.8 for the next 12 cells which is until Mar-15. I have attaches the examples for your quick reference.
Please feel free to modify the date/month formats.

With Regards,
Venu

Put this formula in C7:

=IF(C$6<$A7,"",IF(C$6>$A7+364,"",$B7))

then copy across and down as required.

Hope this helps.

Pete

Many thanks. Working great.

Glad to be able to help - thanks for the rep.

Pete