Chapter 4 Looking things up ・ MISSION 16

Mission 16: Show “-” when not found

📋 Mission list

Task

In B2:B5, show the unit prices. For codes that are not in the price list, show “-”. Use XLOOKUP.

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 16

Show “-” when not found

In B2:B5, show the unit prices. For codes that are not in the price list, show “-”. Use XLOOKUP.

Now
Goal

The tutorial is On. Change this in theMission list.

Functions used in this mission

Example formula: =XLOOKUP(A2,$D$2:$D$6,$E$2:$E$6,"-")

XLOOKUP takes the lookup column and the return column separately. The fourth argument sets what to show when nothing is found (no need to wrap it in IFERROR).

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