Looking for an excel formula for product listing!

I have a master product listing, I then have a separate tab of the products by category (header), for example, Naturel Lip Butter (product) is in the Lip Butter (category). On my master product listi...