Chapter 4 Looking things up ・ MISSION 15
Mission 15: Look up prices for every row (lock with F4)
Task
In B2:B5, show the unit price of each code. Enter the formula in B2 and copy it down.
B2fx
A
B
C
D
E
1
Code
Unit price
Code
Unit price
2
P02
P01
120
3
P05
P02
98
4
P01
P03
450
5
P03
P04
300
6
P05
150
7
Select a range by dragging with the mouse or with the arrow keys while typing a formula. Type part of a function name and press Tab to complete it.
Chapter 4 ・ MISSION 15
Look up prices for every row (lock with F4)
In B2:B5, show the unit price of each code. Enter the formula in B2 and copy it down.
A
B
C
D
E
1
Code
Unit price
Code
Unit price
2
P02
P01
120
3
P05
P02
98
4
P01
P03
450
5
P03
P04
300
6
P05
150
7
A
B
C
D
E
1
Code
Unit price
Code
Unit price
2
P02
98
P01
120
3
P05
150
P02
98
4
P01
120
P03
450
5
P03
450
P04
300
6
P05
150
7
The tutorial is On. Change this in theMission list.
Functions used in this mission
Example formula: =VLOOKUP(A2,$D$2:$E$6,2,FALSE)
If you copy down without $, the table range also moves down one row at a time and you get #N/A. Lock the lookup table with F4.
To practice one function at a time:Function drillExcel function list
* This is a simulation of Excel calculations and may differ in some ways from how Excel actually behaves.
* Some actions may not work depending on your browser environment (for example, shortcuts used by extensions).