Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on May 7, 2019
//EDIT Hi everyone, I have a major apology to make. A few months back I created a solution that shrank the size of arrays my client was doing SUMIF and COUNTIFs on. I used a method similar to the one presented in the video I released today. It made their spreadsheet much more manageable.
But I wanted to adapt it to make it easier to understand. And, in doing that, I really lost that VLOOKUP already has a faster way to operate. So, this video I presented, while interesting in its technical solution is not the BEST way. The best way would be to change the VLOOKUP parameter to false.
Several people pushed back on my video and I want to thank them (and in particular Wim Gielis). This caused me to open my laptop on the train while on the way to a client’s office. When I realized I was wrong I became so deep in thought I missed my stop. And that’s when my phone died.
Anyway, I think it’s important to learn from mistakes. I don’t plan to take this video down because I don’t want to hide behind my error. But I will add a note at the beginning of the video later today when I am back home. Thanks to everyone who watched it anyway. My desire for a complicated solution is sometimes so great that I miss what’s already in front of me.
Wim Gielis, wanted me to also add this note:t an approximate lookup can lead to a wrong result. All people looked up should be part of the database. Or test for it. Second caveat, database must be sorted on names.
//ORIGINAL In this all new episode of Excel.TV, I show you how to make faster VLOOKUPs in Excel. Watch the video to see my advanced Excel Tutorial.
It really all comes down to decreasing the search range. In the video, I show you the old way of doing lookups - selecting an entire range. By creating a lookup table, or as a I call it, a "phone book table of contents," you can tell Excel where in the large database you'd like to search. We achieve this by creating dynamic ranges which tell us where within the entire Excel database to look. Watch the episode to get the full instruction!