I have a Google Sheets workbook with 2 worksheets. (I suspect the solution is the same for Excel or Google Sheets, and if need be, I can switch to Excel)
Sheet 1 lists about 1000 items (components). The list could grow.
Sheet 2 lists some products (200 or so at the moment, but the list could...