VLOOKUP in Excel: Excel learning resource
VLOOKUP in Excel
A slower, argument-by-argument beginner walkthrough than the other lookup videos on this site.
What this video actually covers
A slower, argument-by-argument beginner walkthrough than the other lookup videos on this site. Stratvert builds one VLOOKUP formula and explains each of its four arguments in turn — lookup_value, table_array, col_index_num, and the match-type flag — using Excel's Insert Function dialog rather than typing the formula from memory. The most useful section for a beginner is the #N/A troubleshooting bit: he shows a VLOOKUP breaking when copied down the column because the table reference was relative, fixes it with an absolute reference (F4), and finally converts the source range into a proper Excel Table so the reference stops being an issue at all.
Where to jump in
What to practice while watching
- Build a VLOOKUP one argument at a time using the practice dataset's product table, using the Insert Function (fx) dialog instead of typing the formula freehand.
- Copy the formula down several rows without locking the table reference and reproduce the #N/A error the video shows.
- Fix it by pressing F4 to make the table_array reference absolute, then copy again and confirm it now works.
- Convert the lookup range into an Excel Table (Ctrl+T) and rewrite the VLOOKUP using the table's structured reference instead of a cell range.
Exercise file
Practice the steps above on a real workbook instead of a blank sheet — no sign-up required.
Download VLOOKUP / XLOOKUP practice dataset (.xlsx)Recommended learning path
Start by watching the lesson once without pausing, then reopen Excel and rebuild the example with your own small dataset. Save one clean practice workbook before moving to the next topic.
Source details
- Channel: Kevin Stratvert
- Format: video
- Level: Mixed
- Topic: Formulas & Functions
Go deeper with this skill
Write formulas that are correct, readable, and resilient when the workbook changes. For this article, the goal is to practice: A slower, argument-by-argument beginner walkthrough than the other lookup videos on this site.
Practice workbook setup
Create a small table with clean headers, sample edge cases, and expected outputs you can check manually.
Practice workflow
- Write the business rule in plain English before writing the formula.
- Build the formula in small pieces and test each piece.
- Use absolute references, table references, or named ranges intentionally.
- Test blanks, missing values, duplicate matches, and unexpected text.
Quality checks
- The formula returns the expected result for normal and edge-case rows.
- References point to stable ranges or tables.
- Someone else can understand the formula after reading the labels around it.
Common mistakes
- Fixing one row without testing the rest of the column.
- Using approximate match or partial criteria without meaning to.
- Letting hidden spaces or text numbers cause false mismatches.
Next actions
- Create three test rows that should return different outcomes.
- Compare the result with an alternate formula or manual filter.
Formula focus: even if this workflow is not formula-heavy, add one check cell that confirms the final output still matches the source data.
