Mysteries of VLOOKUP Function Revealed! 15 Amazing Examples! (Excel Magic Trick 1514)

Need to learn all about VLOOKUP? Microsoft Excel MVP & Highline College Professor, Mike “excelisfun” Girvin, presents 15 amazing VLOOKUP examples, from the basics to advanced.

In this video Learn all about VLOOKUP. Learn from Basics to Advanced. See 12 amazing examples that will help you become a VLLOKUP Excel Master! Video taught by Microsoft Excel MVP and Excel YouTuber, Mike Girvin.
Topics:
(00:06) Introduction
1. (01:32) VLOOKUP is everywhere
(04:24) The different between Exact Match & Approximate Match Lookup
2. (06:00) VLOOKUP to Lookup Product Price (Exact Match Lookup)
3. (12:25) VLOOKUP to Lookup Straight Commission Rate (Approximate Match Lookup)
4. (18:32) Data Validation List & VLOOKUP
5. (21:45) Copy VLOOKUP Down a Column. Learn about Relative and Absolute Cell References.
6. (27:00) Dynamic Lookup Table: Excel Table feature
7. (31:47) Dynamic Data Source: Use Power Query to import Lookup Table
8. (36:14) VLOOKUP to Lookup Variable Commission Rate (Approximate Match Lookup)
9. (41:00) VLOOKUP & MATCH Function for Two-Way Lookup (Lookup Employee Information)
10. (48:02) Fuzzy Lookup = Incomplete Lookup Value
11. (51:50) VLOOKUP & IFNA Functions to Avoid Errors
12. (53:05) Partial Text Lookup & Converting Text Number to Number
13. (56:28) Avoid Zeros from VLOOKUP to Empty Cells
14. (58:27) Multiple Table Lookup with VLOOKUP and INDIRECT Functions
15. (01:04:40) Two Lookup Values
(01:08:29)Summary

[LeilaGharani]

Congratulations on 500k! This week is VLOOKUP week :) Love the detailed explanation and variations!

[klarawijs]

If there will come a time when all yt channels will go away, yours is the only one that truly has to be kept online. It's pure gold!

[rrrprogram]

So we are back in future.... Everyone starts excel with Vlookup... Thanks for great examples....
Never imagined vlookup video could be one hour long.. Hah

[pctLowBattery]

I’m always confused when I come to these videos and see dislike. Like Who does that?

[FireUpThePyroMania]

I love the way you show mistakes, and explain everything in bite sized pieces; every little detail and then repeat it a couple of times, so much easier to grasp and memorize.

[mohamedchakroun]

Amazing like always Master...No comment ... Thumbs up :-) and thumbs down for whom putting thumbs down

[pkleong]

I have viewed many YouTube instructional clips. You are by far the BEST. Precise, to the point, no deviation away from the subject matter and ahhhhs and emmmms.
You have designed a step by step instruction by smart usage of the worksheets.

Yes. You are right. I have been using long “If” argument when Vlookup can do the job. Thank you. Great job.

[andrewjohnson]

HEY!! You got Power Query into this example! I have been going thru playlists studying Power Query, Power BI and Power Pivot and this video really hit home. I can feel it in my bones! Its all starting to click! 👍

[ismailismaili]

Hi Mr. Mike again you made it so easy for every single person to understand how to use LOOK up function even if he doesn't know any thing about excel thank you.

[AshokSharma-jqpd]

great, great vlookup video. But i'm unable to find the files.

[DIGITAL_COOKING]

I watched the video for the second time and the coolest thing is that more you get the experience more you assimilate
Unfortunately, I can't hit the thumbs up twice so I give it in this comment👍🙂

[Simlaoui]

Nice video as usual. and yes you did it : 500k subscribers very well done and well deserved. thank you.

[pr]

First I click like and then I watch your videos.

[pauladrian]

OMG! I learned more a lot in your videos than attending my computer classes! Good job. Continue helping students. Thanks a lot

[shaver]

Hi Mike, I love your Videos. The quality of your videos are very high, some teacher should watch you. Greets

[Cooking-vy]

Excellent explanation thank you very much

[datascientistoflife]

really awesome the use of table I haven't seen anyone in this combination

[joelngige]

It's always fun to come back and refresh the lessons. I just did. Awesome!!!! Love your channel the detailed lessons and the homework's. The level of organizations for the follow along and homework workbooks makes life easy

[mamadoubah]

Again another great video! Thank you,

[vero]

I put like before watching ! I know these videos are amazing ! Thanks!