Month: March 2016

March 22, 2016 David Taylor No comments exist

Spreadsheet models can become error prone, labour intensive and unable to scale if they are allowed to grow un-checked.  A culprit is the VLOOKUP formula. LOOKUP allows authors to connect and cross-reference between tables of values from one area or document to another. Workbooks that are reliant upon VLOOKUP formulae can be re-structured to more cleanly combine…