In Sheets, with the SKU in B2, SKUs in H2:H4 and prices in J2:J4, type the XLOOKUP that returns the price or "missing".
In Sheets, with the SKU in B2, SKUs in H2:H4 and prices in J2:J4, type the XLOOKUP that returns the price or "missing".
Answer
=XLOOKUP(B2, H2:H4, J2:J4, "missing")
Lookup value, lookup array, return array, if-not-found. Exact match by default; the return array may sit left of the lookup array.