Psychologist Abraham Maslow wrote a line that is often referred to as Maslow's Hammer. It goes something like this: "I suppose it is tempting, if the only tool you have is a hammer, to treat everything as if it were a nail." I've heard the simplified version more often: "If all you have is a hammer, everything looks like a nail."
The sentiment here is we tend to over rely on a familiar tool. Because VLOOKUP is such an incredible function, this can happen to Excel users. We tend to use VLOOKUP for everything. But, here's the hack. There are other options that are often better suited to the task at hand.
So, in this, the final video in the VLOOKUP Hacks series, we'll explore several alternatives to VLOOKUP.
Written tutorial:
www.excel-university.com/vloo...
Subscribe to blog and view all posts:
www.excel-university.com/blog/