Task 1 of 2
In F2:F5, look up the item name for each SKU. If the SKU does not exist, show "Not in catalog".
Lesson theory
XLOOKUP is the modern replacement for VLOOKUP (Excel 2021 and Microsoft 365):
=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found])- it looks in any direction, so the key does not have to be in the first column;
- it finds an exact match by default;
- it can show your own text when nothing is found.
Enter — commit · F2 — edit · F4 — $ in a reference · Ctrl+C/Ctrl+V — copy and paste · Ctrl+Z — undo
Esc or F6 — leave the sheet for the «Check» button · Shift+Tab in the first cell — back to the page