Chapter 4 Looking things up ・ MISSION 17

Mission 17: Look up a value to the left (INDEX and MATCH)

📋 Mission list

Task

In F2:F3, show the code of each product name in column E. The code is to the left of the name, so VLOOKUP cannot find it.

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 17

Look up a value to the left (INDEX and MATCH)

In F2:F3, show the code of each product name in column E. The code is to the left of the name, so VLOOKUP cannot find it.

Now
Goal

The tutorial is On. Change this in theMission list.

Functions used in this mission

Example formula: =INDEX($A$2:$A$6,MATCH(E2,$B$2:$B$6,0))

MATCH finds the position, and INDEX returns the value at that position. It works even when the return column is to the left of the lookup column.

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