Return value based on product name

Dear members of this wonderful forum,

I've got a question, I got a line of products which all belong to a specific category.
I am trying to come up with a formula that automatically recognizes the product name and category it is in and fills this in in column B of the "Products-sheet".

All unique products with their categories have been listed in the "Categories-sheet", which should be used as a basis to determine the category of the product in column B.

Hopefully one could help me with this, see attached file.

Thanks very much in advance, and wishing y'all a great day ahead!

Kind regards,

Post

How about

Formula:

=INDEX(Categories!$B$2:$B$200,MATCH(A2,Categories!$A$2:$A$200,0))