Chapter 4 Looking things up ・ MISSION 14

Mission 14: Look up a price by code

📋 Mission list

Task

In B2, look up the unit price of the product code in A2 from the price list on the right.

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 startsLooking things up

Chapter 4 ・ MISSION 14

Look up a price by code

In B2, look up the unit price of the product code in A2 from the price list on the right.

Now
Goal

The tutorial is On. Change this in theMission list.

Functions used in this mission

Example formula: =VLOOKUP(A2,D2:E6,2,FALSE)

VLOOKUP searches the leftmost column of the table and returns a value from the column you specify. FALSE at the end means “exact match only”.

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).