How to Use VLOOKUP in Excel? - Complete Step-by-Step Guide
Last Updated: August 19, 2026 | Reading Time: 10 minutes
Welcome to the most comprehensive guide on "How to Use VLOOKUP in Excel?" - one of the most powerful and popular Excel functions.
1. Introduction to VLOOKUP
VLOOKUP stands for "Vertical Lookup". It is used to search for a value in the first column of a table and return a value in the same row from another column.
VLOOKUP is one of the most frequently used functions in Excel for data analysis and reporting.
2. VLOOKUP Syntax
💡 Formula: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
- lookup_value: The value to search for
- table_array: The range containing the data
- col_index_num: Column number to return
- range_lookup: FALSE (exact match) or TRUE (approximate match)
3. Step 1: Prepare Your Data
Example Data: Employee table with Employee ID and Name.
| Column A | Column B |
|---|---|
| Emp ID | Name |
| 101 | Rahul |
| 102 | Priya |
| 103 | Amit |
4. Step 2: Enter VLOOKUP Formula
- In Cell E1, enter the Employee ID you want to search (e.g., 102).
- In Cell E2, enter the formula:
=VLOOKUP(E1, A:B, 2, FALSE) - Press Enter.
- Excel will return the name: Priya.
5. VLOOKUP Examples
📊 Employee Lookup
=VLOOKUP(A2, Sheet1!A:D, 3, FALSE)
📈 Product Price
=VLOOKUP("Product1", B:E, 3, FALSE)
📊 Student Marks
=VLOOKUP("RollNo", A:C, 3, FALSE)
6. Common Errors and Solutions
| Error | Cause | Solution |
|---|---|---|
| #N/A | Value not found | Check lookup value or use IFERROR |
| #REF! | Invalid column reference | Check col_index_num |
| #VALUE! | Incorrect data type | Check data types |
7. Frequently Asked Questions
❓ What is VLOOKUP in Excel?
VLOOKUP is a function that searches for a value in the first column of a table and returns a value from another column.
❓ What is the syntax of VLOOKUP?
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
❓ What does #N/A mean in VLOOKUP?
#N/A means the lookup value was not found in the table.