Data Entry - Force Selection

[blimbert]

Hello - I have a user that has a lot of data entry to manually enter. I want the user to be forced to select from roughly 2,000 different answers. I am having a tough time thinking of how to do this so that the user can type a few letters of the data, and have excel show them the various entries that are available to select from. I'm imagining a sort of autofill meets data validation?

For example, if the user started typing "sweater", I'd like them to select from the following list of sweaters (from the broader list of 2,000 different answers). Then they could just select from a drop down list of the appropriate sweater they desire.
Infant's Sweater
Toddler's Sweater: Cardigan
Toddler's Sweater: Pullover
Toddler's Sweater: Vest
Boy's Sweater: Cardigan
Boy's Sweater: Pullover
Boy's Sweater: Vest
Girl's Sweater: Cardigan
Girl's Sweater: Pullover
Girl's Sweater: Vest
Men's Sweater: Cardigan
Men's Sweater: Pullover
Men's Sweater: Vest
Women's Sweater: Pullover
Women's Sweater: Vest
Maternity Sweater: Cardigan
Maternity Sweater: Pullover
Maternity Sweater: Vest

Thoughts?

 

[kobebryant]

Hi, kobebryant
Welcome to the Forum.

So in col C, which one has to appear, Name or Code?

I don't understand, can you explain it using an example?

When i input to Col B, also it appears NAME
or I input NAME, it apears LIST. This is two ways to input quickly if I remember NAME or LIST.
Thank you

 

[kobebryant]

Hi, kobebryant
Welcome to the Forum.

So in col C, which one has to appear, Name or Code?

I don't understand, can you explain it using an example?

forum cannot update xlsm, i share my example link

OneDrive

Sign in to your OneDrive cloud storage and Office Online.

1drv.ms

 

[Akuini]

Hi, @kobebryant

Sorry for the late reply.
I think this question is related to your question in another thread (link), so please reply in that thread.