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