## 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...

mathetes

Silver Contributor

Attached is an example of how VLOOKUP can refer to a year and retrieve from a table the associated growth rate. Your application may well (probably does) require modifications to that, but it illustrates the use of a table and VLOOKUP

AnnMitchell855

Sep 25, 2024Copper Contributor

I'm targetting the correct growth rate already - what i need to be dynamic is the base figure the rate is applied to. Thanks for trying to help