“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: Index Match

In this modelling guide, we will consider how to match a date dependent constant with its corresponding date on a horizontal timeline. The functions used are INDEX and MATCH.

Help make the handbook better