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

#MSExcel #VLOOKUP #LOOKTIPSnTRICKS

[Evilkiller-mx]

Hasaan is dangerously cool with his excel skills and teaching skills.

[harrievermeer]

Vooral het laatste voorbeeld, especially the last example 👍

[eneto]

Really useful and pretty clear explanation! Tks a lot!

[excelexcellence]

Today I learn couple of very impressive technique in excel using V Lookup. Highly appreciated your work.

[ozgur]

Hope, everything is well, please continue uploading.

[rickperry]

Very helpful. I learned something today, and I have been using Excel for around 20 years.

[amandeepsinghbassi]

runtime error 1004 method onkey of object _application failed SIR HOW TO GET RID OF ERROR WHEN OPENING .xls (EXCEL 2007) File in office2016 . any possible solution

[usmaniqbal]

Sr, can't file open, error of this vlookup excel file, plz share again this file, thanks

[MrImaddah]

very good weclome to my channel about data visualization where i visualize things like rates, speed using xls and power points

[ahmedmohammad]

Bro if you want to teach well then with your clear voice make sure you have a clear view and larger font
It was useless