Retrieve multiple values from range2 based on single criteria from range 1

Hi,

I have a product listing containing 2 columns of data. Column 1 is the 'product category' and column 2 is the 'name of the product'. See attache example.
On a separate sheet I want to be able to select a 'product category' using a list (no problems with that) and have it return all the products associated with the category. Can anyone help please?