Hi all,

I'm looking to do somthing that is out of my knowledge. Here is today challenge...

I have a list like that look like this :

Mech Part Offset Opening
Part 1 12 15
Part 2 15 42
Part 3 34 89

What I want to do is to create a dropdown list on an another sheet allowing to select the Mech Part (which I've done). Now, what I want if when I select let say "Part 1" from the list, I want the info associated with it to be shown in others cell.

Example.

I have the droplist in cell A1. When I select "Part 1", I want excel to write in cell B1 the correponding offset and in cell D22 the corresponding opening.

If anyone know, it would be greatly appreciated. I've been scratching my head for 3 hours now...