Forum Discussion

Stephanyy's avatar
Stephanyy
Copper Contributor
May 01, 2020

Function that capture formula pattern

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?
excel
Formulas and Functions

1 Reply

  • wumolad's avatar
    wumolad
    Iron Contributor
    May 03, 2020

    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.

Resources