Excel VLOOKUP: 5 Advanced LOOKUP Tricks You MUST Know

Learn how to use VLOOKUP in Excel in this beginner to advanced level tutorial for free. Microsoft Excel and VLOOKUP Function are synonymous. In this quick guide, you will learn 5 (five) advanced VLOOKUP tricks including VLOOKUP with approximate match, VLOOKUP with wildcards, 2D VLOOKUP, or two-dimensional lookup, 3D VLOOKUP or three-dimensional lookup and finally how a single VLOOKUP formula can return multiple values or results. Starting with the VLOOKUP vs IF comparison we learn how even a simple VLOOKUP function in Excel can outperform a complex nested IF formula. A must learn trick for every Excel beginner. Using Excel VLOOKUP with wildcard characters like asterisk *, question mark ? and others, we can greatly enhance the usability of VLOOKUP formula in Excel in daily use. And we will learn how to apply VLOOKUP on text strings. 2D and 3D VLOOKUP are the most recommended techniques every avid Excel VLOOKUP user should learn. With these two techniques, you not only learn how to use MATCH function in combination with VLOOKUP formula in Excel but also how to jump data ranges based on criteria. Lastly, we round up our series by learning how to use single VLOOKUP formula to return multiple values or results i.e. getting multiple results in one go! Time Stamps: 00:00 Intro 00:15 VLOOKUP on data divided in brackets like Tax brackets 00:49 Simplifying the data in Excel for VLOOKUP application 2:19 VLOOKUP Function vs IF Function 3:30 Nested IF statements or Nested IF formula 3:53 VLOOKUP with Approximate match 4:43 How VLOOKUP Approximate match works 6:22 VLOOKUP with Exact match using wildcards 7:44 Wildcards - What and why they are needed 8:40 2D Vlookup or two dimensional VLOOKUP 9:35 VLOOKUP and MATCH Function 11:13 3D VLOOKUP or three dimensional VLOOKUP 12:07 BONUS Tip: How to name a data range quickly 13:02 VLOOKUP and INDIRECT Function 15:10 VLOOUP Array Formula 16:03 VLOOKUP Formula to return multiple values Download the Fully worked Excel Workbook with sample data to practice along https://bit.ly/2P7iUF2 #MSExcel #VLOOKUP #LOOKTIPSnTRICKS