Autocomplete from list

[sick stigma]

In the attached workbook I would like to autocomplete B2 as I type from list J2:J37.
Is this possible?
Sick

[Logit]

.
Here is one way without VBA :

Copy your list (J2:J37) and paste into B3.

Now hide rows #3 to the bottom of the list.


Each time you type in B2, it will autocomplete based on the list contents that are hidden.

[sick stigma]

Thank you.
That's slick but B3:B11 already have contents.
Is there another way?
Sick

[Logit]

.

Method #1 (has autocomplete):

https://www.extendoffice.com/documen...ocomplete.html


Method #2 (no autocomplete, acts like a dropdown):

Data Validation

http://www.contextures.com/xlDataVal01.html