Task 1 of 2
In F2:F4, look up the item name for each code in column E.
Lesson theory
=VLOOKUP(lookup_value, table, column_number, 0) finds a row by a value in the first column of the table
and returns the value from the column you choose.
The last argument 0 (or FALSE) means an exact match. Lock the table reference with $.
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