Rolling Match Formula?

[Joe91r2]

Hi there

I'd really appreciate some help with this: I have annual dates in cell A1, A2, A3. A1=Formula that pulls the current year (which as of today is "2018", A2="+A1-1" and A3="=A2-1"

In cell A8,9,10 I have these annual dates hardcoded (so A8=2018, A9=2017, A10=2016. I have the growth rates hardcoded in B8,9,10 (so B8 =3%, B9=4%, B10=5%)

I am trying to get a formula for cell B1,2,3 that will pull the correct growth rate that corresponds to the year above in cell A1,2,3 even as these year roll forward. So when we get to 2019 and cell A2 automatically updates to 2018, the growth associated with "2018" will move from cell B1 (where it would be today), to cell B2.

Any advice would be great!

thanks

[AliGW]

Have the growth rates in a lookup table somewhere and then use VLOOKUP.

[Sam Capricci]

vlookup in B1 dragged down?
=VLOOKUP(A1,$A$8:$B$10,2,FALSE)

[Joe91r2]

Thank you both! This works perfectly!

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.