Autofill cell based upon two different cells

[drigby]

I am sorry if this has already been addressed, but I am not finding what I am looking for so I thought that I would just try posting the question.

What I am working on is a standard excel template for three different locations. Each location has its own set of hardware, and each piece of hard ware has its own part number.

I am already having the user use a pull down to select the location.
What I am then wanting to do is have the hard ware pull down automatically adjust for the location to select the hardware(I am thinking that I am going to be using indirect and vlookup to get this done)
After the hard ware is selected I want the next cell to automatically put in the part number for that piece of hardware. this is where I am scratching my head on the best way to do this.

I am currently using Office 2012.

Thanks for your time and any suggestions.

darren

[Legs]

Am I right in thinking if "Plant 1" is selected the parts list will show: screw A, screw D and screw G?

[drigby]

Legs: Sorry my browser is not letting me respond directly to your question.
But the answer is no.
Plant 1 will have screw A, B and C
Plant 2 will have screw D, E and F
Plant 3 will have screw G, H and I

does that help.

I have attached a revised example showing what my desired output is.

[Legs]

Have a look at the attached, it should do what you are after.

[drigby]

Legs:

That is what I was trying to do. but it looks like I was going the wrong direction in my thinking on how this would of been done.

Thank you I will take this and apply it to my actual document.

[Legs]

Glad I could be of help.