In Sheets, with the SKU in B2 and the products table in H2:J4 (sku, product, unit_price), type the lookup that returns the unit price, ready to fill down.
In Sheets, with the SKU in B2 and the products table in H2:J4 (sku, product, unit_price), type the lookup that returns the unit price, ready to fill down.
Answer
=VLOOKUP(B2, H2:J4, 3, FALSE)
Lookup value, absolute table, column 3 of the table, exact match. A100 → 24, C300 → 180, D400 → #N/A.