I have a drop menu with part numbers, which I pull from another sheet, there
are descriptions associated to those part numbers.

What I want to do is on the drop menu sheet when Part number A is selected
in the drop menu of C7 cell then display the part description in D7 for part
number A

There are about 10 part numbers to choose from

Any help would be greatly appreciated

Thanks in advance

--
Neall