Excel VLOOKUP Practice Question: Find the total amount for each order (quantity times the unit price from the…
The question
Find the total amount for each order (quantity times the unit price from the price list in E2:F5) and put it in C2 and C3.
The data
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Product | Qty | Total | Product | Price | |
| 2 | Pen | 10 | ? | Pen | 12 | |
| 3 | Bag | 3 | ? | Bag | 640 | |
| 4 | Book | 85 | ||||
| 5 | Marker | 25 |
The yellow cells are where your answer goes.
Show answer
Expected results:
- C2 = 120
- C3 = 1920
How it works
Explanation: VLOOKUP returns a value, so you can multiply it like any number. This is a very common billing formula.
Syntax: =B2*VLOOKUP(A2,$E$2:$F$5,2,FALSE)
Pen: 10 x 12 = 120. Bag: 3 x 640 = 1920.
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…
- Using VLOOKUP with MATCH to pick the column automatically, find the units for the…
- Using VLOOKUP with a wildcard, find the price of the first laptop in the list whose name…
All practice questions · Excel exercises · Interview prep · Cheat sheet