List item Based on Cell value

S

Soniya

Hi All,

I have a data validation list in a cell having more than
500 items.

is it possible to have selected items to show on the drop
down list based on the first letter/letters i enter in
the cell? My list is already sorted alphabatically.

like if i type M in my cell the dropdown list show only
items starting M and in case i enter ME all items
startinf ME and like wise..?

TIA

Soniya
 
Top