Home › Practice questions › VLOOKUP › Question 13

Excel VLOOKUP Practice Question: Employees to pay a bonus are in A2:A6 and the salary table is in C2:D6.…

By Rinkesh Shah, founder of Cellgrids.

The question

Employees to pay a bonus are in A2:A6 and the salary table is in C2:D6. Calculate each bonus (10% of salary) in F2:F6, looking up the salary with VLOOKUP.

The data

	A	C	D	F
1	Employee	Name	Salary	Bonus
2	Karan	Amit	52000	?
3	Rahul	Neha	61000	?
4	Amit	Rahul	47500	?
5	Neha	Priya	58000	?
6	Priya	Karan	66000	?

The yellow cells are where your answer goes.

Show answer

Expected results:

F2 = 6600
F3 = 4750
F4 = 5200
F5 = 6100
F6 = 5800

How it works

Explanation: VLOOKUP returns the salary, and multiplying by 0.1 gives 10% of it. You can combine a lookup with any calculation.
Syntax: =VLOOKUP(A2,$C$2:$D$6,2,FALSE)*0.1
Karan earns 66000, so the bonus is 6600. Rahul earns 47500, so the bonus is 4750.

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.