I have a list of 6000 products in column A of sheet 1of a workbook. In the
next sheet I have a column of those 50 products company X uses, 130 products
that company Y uses, etc.
If I add the column headings for each company to sheet 1, how can I bring to
that column something (like the number "1") if that product is used by the
company in that column?