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

J

Joseph Weisblatt

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

Top