Drop-down list question

**darrellb** · 11-19-2010, 05:16 PM

I'd like to create a drop-down list, preferably one where the person can also type instead of mousing down to a specific 4-digit code.

Question 1 - How is this done?

Questions 2 - In the cell beside this list, I'd like it to auto-populate a title -- Is this possible?

**Richard Buttrey** · 11-19-2010, 05:42 PM

Hi,

1. Use Data Validation and choose the List option. If the list is on another sheet you'll first need to name the range then use the name in the list option.

2. Where are the titles. Are they in another table alongside the values you want to pick from the list? If so use a VLOOKUP formula in the adjacent cell and use the data validation cell as the first term in the VLOOKUP()

HTH

**rgi** · 11-19-2010, 05:48 PM

Typeahead does not work with either ActiveX controls embedded into a worksheet or with the Data Validation Listbox control. It does work on Listbox controls on VBA forms.
Cells will typeahead themselves if there is a list above them. Sometimes developers will hide the rows they need and freeze panes to make this work.

As far as adding a label (that I assume corresponds to the number input) use the index and match formulas (or use VLookup) to look up the value next to the number the user input.

**teylyn** · 11-20-2010, 04:31 AM

Type ahead is not the requirement, as far as I can see. With a data validation list, you can either use the drop down or simply type the value into the cell.