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.