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

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

Dear Friends,

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

2. ## Re: Identify start month and repeat the same value in the next 12 cells

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

3. ## Re: Identify start month and repeat the same value in the next 12 cells

Many thanks. Working great.

4. ## Re: Identify start month and repeat the same value in the next 12 cells

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

Pete

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1