Objectives: Formulate the intermediate calculations in Post$-$Retirement Module as well as the

objective $$Age When Funds Gone$.$

o Use VLOOKUP to build connection to the Pre$-$Retirement Module

o Use INDEX and MATCH functions to build objective function

o Use IF function in Post$-$Retirement Module

$$ Excel example to refer:

o VLOOKUP: $6.$ Lookup$$

o MATCH & INDEX: $7.$ PositionValue$$

o IF: $4.$CommonlyUsed$$

$$ Videos to refer:

o VLOOKUP: $$E$.$ Lookup Functions: VLOOKUP and HLOOKUP$$

o MATCH & INDEX: $$F$.$ Functions Building the Connection between Position and Value:

MATCH, INDEX$$

o IF: $$C$.$ Some Commonly Used Excel Functions$$ Part $1.$

$$ The Post$-$Retirement Model consists of a $7-$column table, with $64$ rows $($Title row excluded$).$

Each row represents one year of using Retirement Funds.

o First row $($row #$28)$ is the initial setup of how to use the retirement fund.