Using Vlookup in Excel

JimD · Dec 20, 2005

Is there a way to have a lookup value displayed when you starting typing the
first couple of letters of the value in the box?

Also, I would like to have a calendar in a drop-down to select a date by
simply clicking on the date. Can this be done in excel?

Niek Otten · Dec 20, 2005

Tools>Autocorrect options

Gord Dibben · Dec 20, 2005

Jim

Yes to both.

See Debra Dalgleish's site for instructions on building a Data Validation with
combined ComboBox which has AutoText.

http://www.contextures.on.ca/xlDataVal10.html

See Ron de Bruin's site for a Calendar drop-down.

http://www.rondebruin.nl/calendar.htm

Gord Dibben Excel MVP

Using Vlookup in Excel

JimD

Niek Otten

Gord Dibben