lists

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

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

Multi layered drop down 1
Data Validation 4
Pivot value not formula 1
Vlookup - value not formula 1
Vlookup - actual value not the formula 3
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Dropdown list data validation - word wrap 0
Filtered drop down list 2

Back
Top