How to replace part of a formula?

[Dyon den Haan]

Dear all,

Currently I would like to change part of a formula, because I use a new table of data for the new year 2018.

Is it possible to easily replace this part of the formula instead of manually doing this?

In this formula below I would only like to change the table from 2017 to 2018 (bold part of formula) as you can see below. 

IF(C$33<=Topsheet!$D$4;SUMIFS(PAI_PMS_2017[[#All];[PAI full hour rate x tarief]];PAI_PMS_2017[[#All];[Activities]];'PIVOT TOTAL'!$B34;PAI_PMS_2017[[#All];[Month]];'PIVOT TOTAL'!C$33;PAI_PMS_2017[[#All];[year_no]];Topsheet!$D$5;PAI_PMS_2017[[#All];[Month]];"<="&Topsheet!$D$4);0)

Hope you can help me with this.

Kind regards,

Dyon den Haan

[#2 · Accepted solution]

Hi Dyon,

Ctrl+H and Replace all _2017 on _2018

[#3]

Dyon,

If you want to make it future-proof, you may even replace it with =YEAR(TODAY())

You will avoid having the same problem next year as well. :)

Cheers.

[#4]

I guess these are separate tables to be kept. Just 2018 is created by copying of 2017 and modifying the formula.