3rd February 2016
VLOOK UP – Excel’s Most Dangerous Function And How To Avoid It – With Simon Hurst
VLOOKUP is one of Excel’s most popular functions and many see its use as the mark of an Excel expert. However, VLOOKUP hides a dark secret that can lead to financial disaster and reputational catastrophe.
Find out what can go wrong, how to stop it going wrong and how to use Match and Index to do more than VLOOKUP could even dream of. Then find out how to avoid lookups altogether.
Download the worksheet
(The speed test exercise has been removed because of file size issues)