Lookup key in a table
A column with unique values (style, SKU, barcode) by which a lookup function finds the right row of another table.
Formula
=VLOOKUP(key; table; column number; 0)
How to read
The key must be unique and of one type: a number and the text “123” do not match.