In this formula, the following arguments are used:
search-value: Products::$A2, an absolute reference to the cell in the Products table containing Product 1.
search-range: Products::A, the column to search for Product 1.
return-range: Width, the column containing the value to return that is associated with Product 1.
match-type: Omitted. If match-type is omitted, XLOOKUP searches for an exact match by default.
Set the if-not-found string
If you wanted to search for a specific product length and return its matching width, as well as the string to return if no match is found, you could use the following formula, which returns "No match":