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.

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