## Forum Discussion

AnnMitchell855

Sep 25, 2024Copper Contributor

# Formula help

=IF($G8="yearly",$Y8*(1+$H8),Y8*(1+$I8)) In this formula Y8 is a growth rate that changes every 12 months. How can i update the formula that it will move that cell reference every 12 cells? I hav...

AnnMitchell855

Copper Contributor

mathetes thanks for the response. I can't post the workbook as it is confidential unfortunately. i aready have a table of growth rates. I'm trying to make the schedule understand that if the year changes then to use the last entry of the preceding year as the basis. I'm trying to do this in a formula i can drag across rather than manually altering every 12 months

mathetes

Sep 25, 2024Silver Contributor

So maybe my sample of a VLOOKUP will help. But without seeing what you're working with--how it's arrayed, etc.--one can only speculate what would help. Can you post a mock-up that replicates the layout without disclosing the confidential info?