Lookup Bootcamp
The Only Course You'll Ever Need about Vlookup, Hlookup, Xlookup, and Index-Match
Enroll in Course
Ready to conquer those spreadsheet lookups once and for all? Lookup Bootcamp is your fast-track, no-fluff guide to mastering VLOOKUP, HLOOKUP, XLOOKUP, and the powerhouse combo of INDEX-MATCH.
In just two hours, you'll learn how to slice through data like a pro, simplify reporting, and avoid those dreaded "#N/A" errors for good.
Whether you're polishing up for your next role, or just tired of googling formulas every time, this course breaks it all down with clear examples, tips, and shortcuts that'll stick.
Level up your Excel game. Your Future Self will thank you.
What's Included
- 25 quick lessons that you can watch anytime around your own schedule
- VLOOKUP, HLOOKUP, XLOOKUP, and INDEX-MATCH tutorials
- Excel file to download and practice with
- 2 hours of learning
- Auto-generated captions
- Opportunities to post on discussion boards and ask questions
- Certificates of completion
- Lifetime access so you don't feel rushed
What You'll Learn
First, in the Introduction to Lookups module, you'll learn:
- why lookups are massive time-savers for connecting datasets;
- how you can apply lookups with tables, Tables, pivot tables, across sheets, and across workbooks; and
- the pros and cons of the 4 types of lookups.
In the Prerequisites section, you'll:
- make a unique list of all the possible IDs ("primary keys"); and
- practice using relative, absolute, and mixed cell references.
In the =VLOOKUP section, you'll go nice 'n' slow through these steps:
- creating a unique list of all the possible IDs/primary keys;
- adding data from the first table;
- adding data from the second table;
- dealing with #N/A errors; and
- using helper cells to speed-up our process even more.
The formulas can get pretty long! There are lots of commas, dollar signs, parentheses, and quotes, and everything has to be in the exact right place, or the whole thing implodes. That's why we'll tackle the formula together in baby steps.
In the =HLOOKUP section, you'll practice almost the exact same steps again.
The formula will be slightly different, since we're dealing primary keys that go horizontally, not vertically.
In this section, you'll progress a little quicker, since it'll be the second time you're writing lookups, dealing with #N/A errors, and adding helper cells.
You'll love the flexibility of =XLOOKUP!
In this section, you'll practice:
- Applying =XLOOKUP to that exact same dataset again (so you can spot the similarities/differences between the V and X versions); and
- Using =XLOOKUP to join a vertical and horizontal dataset.
INDEX-MATCH is the Queen Bee of lookups!
In these lessons, you'll:
- learn how the formula structure of INDEX-MATCH is similar/different to V and X lookups;
- practice writing INDEX-MATCH formulas in 3 scenarios: based on 1 row, based on 1 row and 1 column, and based on 2 rows.
In other words, you'll be fluent in this jargon:
Finally, in the Slight Variations section, you'll use lookups:
- with Excel Tables;
- across sheets;
- with Excel Tables across sheets;
- across workbooks; and
- with pivot tables (to make maps and new-ish charts, like this sunburst diagram). Helper Tables with lookups are a required workaround in order to create maps, tree maps, sunburst diagrams, waterfalls, and other charts in dynamic dashboards.
About the Instructor
Your Instructor
Ann K. Emery is an internationally-acclaimed speaker who equips organizations to get their data out of dusty spreadsheets and into real-world conversations.
Each year, she delivers over 100 keynotes, workshops, and webinars with the aim of equipping organizations to visualize data more effectively.
She has been invited to speak in 31 states and 11 countries; 10,000 people have enrolled in her online training academy; and she has consulted to 200 organizations, including the United Nations, Centers for Disease Control, and Harvard University.
She earned a Bachelor’s degree from the University of Virginia and a Master’s degree from George Mason University.
After traveling full-time as a digital nomad, Ann now resides in Florida along with her husband and five children.
FAQs
Frequently Asked Questions
Early Bird Bonus
We've got a special gift for the first 25 people who enroll: a 45-minute consultation is included with your course tuition!
Here's how it works:
- You'll complete the 2-hour course.
- Then, you'll automatically receive an email with a link to schedule your 45-minute consultation.
- We'll meet live over Zoom.
- We can use the time however you'd like! You might: Ask advanced how-to questions; bring your own dataset and get the instructor's feedback; or pick Ann's brain about another topic of your choice.
- The session isn't recorded or posted anywhere.
- You can use your 45-minute session anytime in 2025.