Exercises / Lookups · 6 of 10
XLOOKUP with a friendly "not found"
XLOOKUP(value, lookup_range, return_range, [if_not_found]) finds a value and returns the matching item. It matches exactly by default, looks in any direction, and takes a fallback for missing values.
Your taskIn G2, use XLOOKUP to return the department of the employee ID in G1. If the ID is not in the list, return "Not found".
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-1057 | ||
| 2 | Arben Hoxha | Finance | E-1031 | arben@northwind.co | Department | ||
| 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 |