How to create many-to-many lookup in Excel
In Excel, you can perform a many-to-many lookup to find multiple values based on a single criterion. This is useful for tasks such as finding all the books that a certain author has written for a specific publisher, or all the products that a certain customer has bought from a specific store.
We will show you how to perform a many-to-many lookup in Excel using different functions and formulas.