Look up a value with VLOOKUP
VLOOKUP takes four things: what to look for, where to look, which column of that range to bring back, and whether an approximate match will do.
Two rules decide whether it works. The thing you are looking for must be in the first column of the range you give it, VLOOKUP only ever reads to the right. And the column number is counted from the start of that range, not from column A of the sheet.
The fourth argument should almost always be FALSE, meaning an exact match. Leave it off and Excel assumes TRUE, which quietly returns the nearest row below your value, fine for banded tables, wrong and silent for codes.
F2 holds the code to find. In G2, use VLOOKUP to bring back the product name for that code, matching exactly.
The grid for this exercise is part of the paid half.
Everything above is yours to read either way. 46 exercises stay free with a profile.