Excel VLOOKUP Practice Question: Find the new salary after a 10% hike for the employee name typed in E2 and put…
The question
Find the new salary after a 10% hike for the employee name typed in E2 and put it in F2.
The data
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Name | Dept | Salary | Name | New salary | |
| 2 | Asha | Sales | 52000 | Chitra | ? | |
| 3 | Ben | HR | 48000 | |||
| 4 | Chitra | IT | 65000 | |||
| 5 | Dev | Sales | 58000 | |||
| 6 | Esha | IT | 61000 | |||
| 7 | Farah | HR | 45000 |
The yellow cell is where your answer goes.
Show answer
Answer in F2: 71500
How it works
Explanation: Combine the lookup with a calculation: fetch the salary first, then multiply by 1.1 to add 10%.
Syntax: =VLOOKUP(E2,A2:C7,3,FALSE)*1.1
E2 is Chitra, whose salary is 65000. 65000 x 1.1 = 71500.
Try it yourself in the live sheet
Type your formula in the highlighted cell and get instant feedback. Free, no Excel install needed.
Try this question in the live sheet →VLOOKUP syntax
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Looks up a value in the first column of a range and returns a value from another column, same row. Pulling an employee's salary into another sheet using their ID. Full VLOOKUP guide.
More VLOOKUP practice questions
- Using VLOOKUP, find the price of the product code typed in E2 and put it in F2.
- Find the department of the employee ID typed in E2 and put it in F2.
- Using VLOOKUP, find the marks of the roll number typed in E2 and put them in F2.
- Using VLOOKUP with approximate match, find each student's grade from the band table in…
- Customer ID is typed in F1. Find that customer's name and city and put them in F2 and F3.
- Using VLOOKUP, fetch the unit price for each ordered product from the price list in…
- Find the total amount for each order (quantity times the unit price from the price list…
- Using VLOOKUP with MATCH to pick the column automatically, find the units for the…
All practice questions · Excel exercises · Interview prep · Cheat sheet