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 listing, I am trying to say "find this product in the categories list, once found, return the category it's in". So again, find Naturel Lip Butter and put that it's in the Lip Butter category. I hope this makes sense lol!