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

J

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.
 
K

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional listbox cell populating 4
Choosing a drop-down menu selection returns value to another cell 2
Conditional formatting? 1
Excel If a Cell Contains a Certain Text (From Another Table) 0
Data Validation List problem 5
Pick from drop-down list gives empty or erroneous result 6
Table with two pick from list columns that need to vlookup each ot 1
populating a list box based on another cell 1

Top