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