Excel List of choice with legend

[DanWo]

Is-it possible to use List of choice (Data/Validation/List)
with Legend.
List Range = A1:A100 (list of codes)
In B1:B1000 are description of the codes (Legend)
When I have to select a code in the List, I would like to see his description,but, when I select the code , only the code itself is selected.

 

[hopelessliar]

It sounds very possible but I think yuo should be a bit more detailed with your question...

I'm imagining that you have a cell (say C1?) which is a validated list from which you choose one of the values from A1:A100. Once this is selected you want to show the associated value from B1:B100 - is this correct?

 

[Bowers74]

I'm afraid that you will have to use two cells to do what you want to do.

In the cell next to the dropdown (I'm assuming that is C1) enter:

=VLOOKUP($C1,$A$1:$B$100,2,0)

This will return the description for the list selection (assuming) your list selection is located in cell C1.

I hope this helps!



Peace!

Mike

Never say Never!!!
Nothing is impossible!!!

 

[combo]

Actually, you can have description while selecting, but this require different approach, using activex control:
1. for simplicity, name range A1:B100 say, the_list, and cell to store selection the_item,
2. display toolbox toolbar (not forms!), select combo box and place it on the sheet. Do not close the toolbar,
3. if the right-click the control, select p\'properties' and format it:
- BoundColumn 1
- ColumnCount 2
- ColumnWidths 20;80 (or other to fit to text)
- LinkedCell the_item
- ListFillRange the_list
4. Click the 'Exit design mode' button.

When you need to change settings, first enter design mode (via button on the toolbox), and exit when finished.
You can also add data validation (list, but without drop-downs) to avoid items outside list.

combo