You receive a file with only Employee IDs. HR asks you to add employee name, department, manager and salary from the employee master. VLOOKUP can search the employee ID and return the matching details.

What does VLOOKUP do?

VLOOKUP searches for a value in the first column of a table and returns a related value from another column to the right.

Simple rule: Use VLOOKUP when your lookup value is in the first column and the information you need is to the right.

VLOOKUP formula structure

Basic syntax

=VLOOKUP(lookup_value, table_array, col_index_num, FALSE)

Example: =VLOOKUP(B4,'Employee Master'!A:H,2,FALSE)

This searches the Employee ID in B4 inside the first column of A:H and returns the 2nd column, which is Employee Name.

Business examples

NeedFormulaResult
Find employee name=VLOOKUP(B4,Master!A:H,2,FALSE)Aarav Shah
Find department=VLOOKUP(B4,Master!A:H,3,FALSE)Sales
Wrong employee ID=IFERROR(VLOOKUP(B4,Master!A:H,2,FALSE),"Not Found")Not Found
FALSEExact match
2Column index
A:HTable array

When to use and when not to use VLOOKUP

Use VLOOKUP whenYour lookup column is the first column and you are working with existing company files.
Avoid VLOOKUP whenYou need to return a value from the left side or want formulas that are easier to maintain.
Use FALSE for IDsEmployee IDs, product codes and invoice numbers should use exact match.
Use IFERRORShow clean messages instead of raw #N/A errors.
💡
PM tip: In real business files, old VLOOKUP formulas are common. Learn VLOOKUP to maintain legacy reports, but prefer XLOOKUP for new files when available.
⚠️
Common mistake: Using TRUE or leaving the last argument blank for ID lookups. Use FALSE for exact match.

Interview question

Question: What is the limitation of VLOOKUP?

Answer: VLOOKUP searches only in the first column of the selected table array and returns values from columns to the right. It also depends on column index numbers, which can break if columns are inserted or moved.

🧪 Practice Lab

Fetch employee details using VLOOKUP

Download one ZIP file containing the practice workbook, challenge workbook, solution workbook, formula cheat sheet, quiz and answer key.

📦 Download Lesson 19 ResourcesWorks as a standalone file and after website deployment

Mini assignment

  1. Use VLOOKUP to fetch Employee Name.
  2. Use VLOOKUP to fetch Department, Location and Manager.
  3. Use VLOOKUP to fetch Salary and Joining Year.
  4. Use FALSE for exact match.
  5. Use IFERROR to show “Not Found” for missing IDs.

Quick quiz

  1. What does VLOOKUP do?
  2. What does FALSE mean?
  3. What is column index number?
  4. Why use IFERROR?

Answers: Looks up a value and returns related data; exact match; column number to return; clean error handling.

FAQ

Yes. Many companies still have old files using VLOOKUP, so it remains useful for maintenance and interviews.
Usually the lookup value is missing, misspelled, has extra spaces, or the lookup column is not the first column of the selected range.