“If you can’t describe what you are doing as a process,
you don’t know what you’re doing”
W. Edwards Deming

Data pickup functions: Vlookup

Model assumptions that are date dependent are presented as constants to facilitate sensitivity analysis. How should such constants be best spread across a horizontal timeline so they match their corresponding dates?

There are a number of Excel functions that might be used to pick constants and allocate them to a corresponding column in a timeline.

This guide considers the use, pros and cons of VLOOKUP.

Help make the handbook better