Excel Newby Needs Help Creating Formula!!!!

[JaysonScheuer]

I have a table that kind of looks like the one below. Over the top is departments and the rows are different items each department may need. The "X" indicates that department is in need of that items.


Sales Marketing Finance Etc.
Paper X X X
Ink/Toner X X
Coffee X X
Soda X X X


What I'd like to do is create a query that allows me to type in a departments name, i.e "Sales", and see what items that department needs based on whether their column has an "X" in that items row. Something like this:

Department Name: [Sales]

Items Needed: Paper
Coffee
Soda

I am not very experienced using Excel but I'm a quick learner, and work in IT so it kinda comes natural? I could really use some assistance though! Thanks in advance.

 

[JaysonScheuer]

Included better visual in this post. Thanks again for any assistance.
=============================================
I have a table that kind of looks like the one below. Over the top is departments and the rows are different items each department may need. The "X" indicates that department is in need of that items.

What I'd like to do is create a query that allows me to type in a departments name, i.e "Sales", and see what items that department needs based on whether their column has an "X" in that items row. Something like this:

I am not very experienced using Excel but I'm a quick learner, and work in IT so it kinda comes natural? I could really use some assistance though! Thanks in advance.