choose a name in list

[ayubali60]

i have a question related to excel. plz help. i have created a list of different products by data validation. now in the new sheet i have applied it now i want to select a product in the list.

now i want this: when i write a letter or 2 letter related to any specific product of the list, is it possible that rest of the name of product shows.

 

[Yongle]

is this what you are looking for? https://www.youtube.com/watch?v=vkPoViUhkxU

 

[ayubali60]

Thanks for reply, this links helps my problem 70 to 90 percent,
Actually I am looking for:

If there are two row are fill with name or some text like.
Samsung usb 32 GB
Headphone wireless
Etc..

When I write only s , to write Samsung usb 32 GB , after writing only s rest of the name shows ,,most nearly names possible match , and I choose among the different words or text which I want to write and choose the text by arrow keys and hit enter to select specific text.