|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 20th, 2005, 07:02 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
Using Vlookup in Excel
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? 
|
|
#2
December 20th, 2005, 07:07 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Using Vlookup in Excel
ToolsAutocorrect options
-- Kind regards, Niek Otten "JimD" wrote in message ... 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?
|
|
#3
December 20th, 2005, 07:58 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Using Vlookup in Excel
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 On Tue, 20 Dec 2005 11:02:04 -0800, "JimD" wrote: 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?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Vlookup formula Excel version 2002 | biz | General Discussion | 0 | September 7th, 2005 01:07 AM |
| Excel 2000 VLOOKUP returns #N/A unless press F2 return on source? | Colin | Worksheet Functions | 3 | August 31st, 2005 01:10 PM |
| Excel Slow When Opening Linked Files with VLOOKUP Functions with > | SkyEyes | General Discussion | 3 | October 27th, 2004 04:14 PM |
| vlookup excel | DDM | Worksheet Functions | 1 | April 28th, 2004 09:02 PM |
| Pocket Excel vlookup function | P | Worksheet Functions | 2 | September 24th, 2003 06:20 PM |
Linear Mode
