How to Use VLOOKUP in Excel (Beginner’s Guide)
VLOOKUP helps you find data in large tables based on a unique identifier — like a student ID or item code.
🔎 Formula:
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
✅ Example:
=VLOOKUP("Apple", A2:C100, 2, FALSE)
Searches column A for "Apple", returns value from 2nd column.
📘 Notes:
- lookup_value must be in first column
- Set last argument to FALSE for exact match
💡 Alternative: Use XLOOKUP in Excel 365 for more flexibility!
🎁 Get a VLOOKUP Practice Template
Free download at ScriptDataInsights
📲 Follow @ScriptDataInsights on Instagram for more Excel formulas and visuals.
Comments
Post a Comment