How to Use VLOOKUP in Excel (with Sample Data)
VLOOKUP is one of the most powerful and commonly used functions in Microsoft Excel. It allows you to search for a value in the first column of a table and return a value in the same row from another column.
📊 Sample Data
| Product ID | Product Name | Price |
|---|---|---|
| 101 | Apple | 30 |
| 102 | Banana | 10 |
| 103 | Orange | 20 |
| 104 | Mango | 25 |
🔍 What We Want to Do
Look up the price of a product based on its Product ID.
🧮 VLOOKUP Formula
Assume you type the Product ID in cell E2.
=VLOOKUP(E2, A2:C5, 3, FALSE)🔎 Explanation
- E2 – The value you want to search for (e.g., 103).
- A2:C5 – The table range containing the data.
- 3 – The column number in the range from which to return the value (Price column).
- FALSE – Means you want an exact match.
✅ Example Result
If E2 = 103, the result will be:
20
Because Product ID 103 is Orange and its price is 20.
💡 Bonus Tip
If you want to search data from another sheet, just include the sheet name in the table range:
=VLOOKUP(E2, Sheet2!A2:C5, 3, FALSE)That's it! You've now learned how to use VLOOKUP in Excel with a real example. Try it out and see how it can save you time!
0 Comments