lists

R

rexmann

Hi

I have created a drop down list in excel which is attached to a table (via VLOOKUP). The drop down list contains a code number. What I would like is a comment next to the list saying what each code represents (eg 100 - stationery) but only putting in the value when selected (as it is part of a formula). does anyone know how to do this?

any help appreciated.

kind regards

Rexmann

Kind regards

Gareth
 
A

AlfD

Hi!

If this is a listbox from the Control Toolbox then you can do this:

Call up the listbox's Properties
Select ColumnCount and enter 2
Select ColumnWidths eg 30, 100 (depends on your data lengths)
Select ListFillRange and enter the lookup list (both columns- th
numbers and the descriptions)

The LinkedCell will show the number as before.

Al
 
Top