VLOOKUP Formula Examples in MS Excel

 VLOOKUP Formula Examples 

Here are some examples of how you can use the VLOOKUP formula in Excel:

1. Look up a product price based on its name:

less
  A          B
1 Product  Price
2 Apple    1.50
3 Banana   0.75
4 Orange   1.00
5 Grape    2.00

=VLOOKUP("Apple", A1:B5, 2, FALSE)

This formula would return 1.50, which is the price corresponding to the product name "Apple" in the table.

2. Look up an employee's salary based on their ID:

yaml
  A       B       C
1 ID    Name  Salary
2 101    John  5000
3 102    Jane  6000
4 103    Bob   7000
5 104    Alice 8000

=VLOOKUP(102, A1:C5, 3, FALSE)

This formula would return 6000, which is the salary corresponding to the ID 102 in the table.

3. Look up a student's grade based on their name:

less
  A        B       C
1 Name  Test1  Test2
2 John    85     90
3 Jane    75     80
4 Bob     95     70
5 Alice   80     85

=VLOOKUP("Jane", A1:C5, 3, FALSE)

This formula would return 80, which is the grade corresponding to the name "Jane" in the second column of the table.