VLOOKUP - Excel's most dangerous function from index match excel function Watch Video
Preview(s): Play Video: (Note: The default playback of the video is HD VERSION. If your browser is buffering the video slowly, please play the REGULAR MP4 VERSION or Open The Video below for better experience. Thank you!)
Your browser does not support playing the video.Please download the video!
⏲ Duration: 30 min 53 sec ✓ Published: 13-Feb-2017
Description: 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. nnFind 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.