MS Excel: Understand The Basics of VLOOKUP in 28 Minutes
Thanks to ExcelIsFun on YouTube!
I recently finished a 90+ minute ExcelIsFun YouTube session — a replay of a training session Mike Girvin put on for Central Washington University.
The topics included basic to advanced discussion of the VLOOKUP function and how to use it for data analysis.
Below I have recapped four segments hitting on the primary VLOOKUP topics to understand. If you are new to the VLOOKUP function — this is a great place to start! You will understand the importance, basics of use and HOW you can get started!
Introduction
- Why VLOOKUP? (02:00)
VLOOKUP Match Types
- EXACT match example and data validation concept introduction (08:47)
- APPROXIMATE match introduction (08:42)
Example VLOOKUP Use — Building Out a Dataset
- Common VLOOKUP use example — expanding a dataset for analysis flexibility (08:40)
To refresh or replay any segment, just REFRESH your browser and you can start over.
Introduction
Why VLOOKUP? (02:00)
VLOOKUP Match Types
EXACT match example and data validation concept introduction (08:47)
APPROXIMATE match introduction (08:42)
Example VLOOKUP Use — Building Out a Dataset
Common VLOOKUP use example — expanding dataset for analysis flexibility (08:40)
If you understand the concepts above, you are well on your way to advancing your data analysis capabilities! Good luck!
About Don
“It’s time for different”
Don is passionate about helping professionals and organizations keep up and adapt to the changing business world that we operate in.
“What Do You Do?”
I frequently get this question. My response (it’s not what you think!)? Check it out here!