Function that capture formula pattern

[Stephanyy]

Hi, I am working on financial forecast template that the first row are the 12 months, first column are variables such as salary, welfare, IT expenses etc. Some of the variables, it only charges in quarterly. I always need to type in formula that making June = March column, Sept = June, Dec = Sept. Is there anyway that like I type a word in one cell or anything, that formula patterns will automatically appear?

[#2]

Hi @Stephanyy 

I am not sure if I totally understand your requirement, but I put something together so you check.

To get Mar when you type in Jun I used the formula below

=IFERROR(INDEX($A$2:$A$13,(MATCH($A$17,$A$2:$A$13,0)-3)),"")

Please check if there is any need to make an adjustment to the worksheet.

Cheers.