| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I get automatic completion to work for an in-cell dropdown
If I have a list of Alpha, Beta, Gamma and an in-cell dropdown, I'd like
typing 'G' to auto-select Gamma. I'm pretty sure it was doing that at some point, but now, it does not. |
|
#2
|
|||
|
|||
|
This isn't supported under data|validation.
You could use A,B,G in the dropdown and then use a helper cell with a formula in it, though. Say you put your abbreviations in A1:A3 of sheet2 and the real names in B1:B3, then you could use: =if(a1="","",vlookup(a1,sheet2!a:b,2,false)) Joseph Weisblatt wrote: If I have a list of Alpha, Beta, Gamma and an in-cell dropdown, I'd like typing 'G' to auto-select Gamma. I'm pretty sure it was doing that at some point, but now, it does not. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatic coloring of blank cells when sheet work complete | Excel Worksheet Functions | |||
| How can I find automatic links in an Excel-sheet? | Excel Discussion (Misc queries) | |||
| Some Excel links don't work | Excel Discussion (Misc queries) | |||
| Update Automatic Links Not Working in 2003 | Excel Discussion (Misc queries) | |||
| Databases for tracking work and task completion | Excel Worksheet Functions | |||
Linear Mode
