“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: Lookup

In this guide, we will look at how LOOKUP might be used to match constants with corresponding dates in a horizontal timeline.

Our example is based on escalation factors – where the last date dependent constant is assumed to apply to all remaining periods in the timeline.

Hence our requirement is for an approximate match.

Help make the handbook better