VLOOKUP with multiple values

Hey Guys,

Having a problem with using VLOOKUP in Excel.
Basically I have a sheet (attached [Test.xlsx]) which I am trying to pull data to from another sheet (attached [Tooling.xlsx]) when the "Tooling Ref" has had a part number inputted into it. Which I can do, and do not have a problem with.

The problem I am having is, I only want data to show up when it has a certain value along that row. It makes sense when you look at the workbooks. I am basically wanting the data to show up that is located in the "PATT SHOP" for instance.

Which is a good 6 rows of data on the "Tooling Sheet" but I want that to show up when the drop down for "PATT SHOP" has been selected on the "Test" sheet if that makes any sense?

I am trying to make it work so all of the data can be selected by selecting a different value from the drop down list?

Hope you can help

Cheers

Nick