How do I get automatic completion to work for an in-cell dropdown

G

Guest

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.
 
D

Dave Peterson

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))
 

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

Automatic Completion Erratic 1
Screen Tip/Auto Completion For UDFs 1
Dropdown list in a locked cell 3
How do i show the drop down arrow for a list in Excel 1
Data validation with dropdown list 2
VLOOKUP or dropdown in the cell depending on selection in another 1
How to return multiple results in a cell 5
How to enter several values separated by return key in a cell 7

Top