Populating a Cell by Choosing from a Pick list in another Cell

[jbanda]

I have a workbook with multiple sheets. In sheet 1 I have created a drop down
list referencing a range on sheet 3. The range referenced are codes for
longer descriptions. I want to select the code from the drop down and have
the description appear in another cell. Unfortunately there are duplicate
codes with different discriptions. So there may be three AAA codes but each
with a different adjacent description.

I would be fine if this were backward. Where I select the description and
the code appears in the other cell.

 

[Kassie]

And then you would have duplicate descriptions! You would have to modify
your codes, such as to change it into AAA, AAA1, AAA2 etc, otherwise no
computer program would make the right choice!