Exercises / Lookups · 4 of 10
Look up to the left with INDEX and MATCH
MATCH(value, range, 0) returns the position of a value in a range. INDEX(range, n) returns the nth item of a range. Together they look up in any direction, including to the left, where VLOOKUP cannot go.
Your taskThe employee ID is in column C and the name is to its left, in column A. In G2, use INDEX and MATCH to return the name of the employee whose ID is in G1. An ID that is not in the list shows #N/A.
Pro
Unlock this exercise and every module after the basics.
Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.
| Row | A | B | C | D | E | F | G |
|---|---|---|---|---|---|---|---|
| 1 | Name | Department | Employee ID | ID | E-1063 | ||
| 2 | Arben Hoxha | Finance | E-1031 | arben@northwind.co | Name | ||
| 3 | Bea Lindqvist | Sales | E-1042 | bea@northwind.co | |||
| 4 | Carlos Ruiz | Operations | E-1057 | carlos@northwind.co | |||
| 5 | Dina Petrova | Sales | E-1063 | dina@northwind.co | |||
| 6 | Emeka Obi | IT | E-1078 | emeka@northwind.co | |||
| 7 | Fatima Zahra | Finance | E-1081 | fatima@northwind.co | |||
| 8 | Goran Ilić | IT | E-1094 | goran@northwind.co | |||
| 9 | Hana Sato | Marketing | E-1102 | hana@northwind.co |