Automate values is specific cells

[Thomas Kuriakose]

Dear All,

We have a sheet which as more than 160 columns. We need a function to automatically input the values of a specific month in specific months. Please find a sample sheet attached. I could only manage relative reference and an if statement. Can we use choose or any other function to make this better.

Thank you so much,

with regards
thomas

 

[Hui]

Can you please be more specific about what your trying to achieve:

Ie: Use cell references and examples

 

[Thomas Kuriakose]

Dear Hui,

We have months from column B onwards to 160 columns (Jan to December) and it continues for different years.

We need value of cell B2 to be automatically entered in the months Jul, Sep, Jan and continue this trend.

I could only manage the values by a relative reference and an if statement, can we use any other function to automate this value.

thanks,

with regards,
thomas

 

[Hui]

I am still confused as to your requirements
Can you give a before and after example ?

Also the list of Months in Row 1 isn't evenly spaced or is that ok?

 

[Thomas Kuriakose]

Dear Hui,

Please find the sheet with the months spread out.

Can we use choose function for this.

thanks,

with regards,
thomas

 

[Thomas Kuriakose]

Dear All,

Kindly help on how to get the specific value in the specified cell.

thanks,

with regards,
thomas

 

[John Jairo V]

Hi to all!

It's confusing your example. If I understand, Try in B4 and copy it to the Right:
=IF(ISNUMBER(MATCH(B1,{"Jan";"Apr";"Jul";"Sep"},)),B2,"")

Please comment! Blessings!

 

[Thomas Kuriakose]

Dear John,

Thank you so much for this. This working perfectly.

Thanks once again.

with regards,
thomas