Retirement Planner Spreadsheet Bug

One issue I’ve encountered with the Retirement Planner Spreadsheet: Any asset account I enter from row 44 onwards does not pull in the current value (column C). If I enter that same asset account between row 25 and row 43 it pulls in the value as expected.

2 Likes

Good catch. Until we post an update, looks like an easy fix. Just change the formula in C24 from:
={"Current Value";arrayformula(IFerror(VLOOKUP(B25:B43,{$AQ$18:$AQ,$AS$18:$AS},2,FALSE)))}
to
={"Current Value";arrayformula(IFerror(VLOOKUP(B25:B49,{$AQ$18:$AQ,$AS$18:$AS},2,FALSE)))}

2 Likes