I want to check which products (listed in rows) are produced by which company (listed in column headings) in order to fill a table like this
Company A Company B Company C
Product 1
Product 2
Product 3
The raw data is stored in a separate Excel worksheet that is designed like this:
Company A Product 3 Product 5 Product 7 Product 10 Product 11
Company B Product 1 Product 7
Company C Product 1 Product 8 Product 9
So I would first need to command Excel to select the right row (=company) and then check whether it contains the product I am looking for. I do not think VLOOKUP in its basic form can help here, since it can only return the value of a specific column. I know there must be an easy solution for this, please let me know if you have an idea! Thank you so much for your help!