Excel VLOOKUP Formula For Beginners
I first started seriously learning Excel on my Masters degree course in 2008. I vividly remember one interaction with a colleague more experienced than me (at least at the time!) with Excel. He was talking about a second colleague and said, ‘She’s really good at Excel, she can do VLOOKUP!’
It seems, for many, the VLOOKUP formula has a kind of symbolic significance. If you know it, you’re good at Excel! And, over the years, I’ve witnessed the impact it can have on the confidence of professionals I’ve worked with. Conquer VLOOKUP and a new world of powerful Excel formulae opens up …
WATCH THE VIDEO HERE
So, can you confidently build an Excel VLOOKUP formula? And, do you know some of the tips and tricks to make VLOOKUP formula building really smooth? There’s even a ‘secret mode’ that we’ll talk about. Yes, not only do we want to use VLOOKUP, we want to use it like a pro …
In this session, I talk you through Excel’s VLOOKUP formula from absolute beginner level. We first discuss the concept, since conceptual understanding always comes first. What does the formula actually do, and how can we visualize its function? Then, we build at least one example step-by-step. I’ll point out tips and tricks along the way and direct you to follow-up videos to consolidate your understanding of VLOOKUP and similar Excel formulae.
So, is this the day you conquer VLOOKUP and take your analytical skill to the next level? Make sure you download the Excel file and work along with me, and don’t forget to let me know how you get on in the comments! I’ll get back to you there …
WATCH NEXT
Do What VLOOKUP Can’t Do With OFFSET And MATCH
Categorise Numbers With VLOOKUP’s Secret Mode
How To Automate VLOOKUP With Excel VBA
10 Excel Data Cleansing Formulae
I Tried To Learn 500 Excel Formulae!
10 Excel Formulae Tips And Tricks
Learn Excel’s Dynamic Array Formulae