i-nth - True Vlookup tragedy

24 October 2015

The VLOOKUP function is often used to prove a bare minimum of Excel knowledge because it's both useful and common. However, VLOOKUP is often not used properly and is a common cause of errors.

Full article: True Vlookup tragedy

Essential reading

Spreadsheets on trial

Every study that has looked for errors has found them in considerable numbers. Spreadsheeting's childhood is over.

Latest articles

Spreadsheets as a source of analytical and accounting problems
Self-checks in spreadsheets: A survey of current practice
The development of a structured methodology for the construction and integrity control of spreadsheet models
Refactoring meets spreadsheet formulas
Simple spreadsheet test case application to test spreadsheet formula in end-user software engineering
Proper VBA error handling
VBA Like operator – using wildcards in conditional statements
Count cells with text and formula – Excel stats
VBA: The VBA array
Excel Tables
An innovative spreadsheet authoring environment

Consulting

We can help you make better spreadsheets:

Reviewing your spreadsheets for errors.
Advice about improving your spreadsheets.
Training in spreadsheet good practice.