Jayesh,

I tried that. No matches were found when I used "=" instead of "=>" operator. Maybe it would help if I told you the names in the table are like

DEXTER
FARGO
KELLSBOROUGH
LARGO
LEALMAN
LESTERVILLE
MANGO
MARYSVILLE
ROCKVILLE

so I entering just the first couple letter of the name in order to do the lookup. But I would like to show the lookup name followed by all the other that follow it alphbetically in the listbox after the lookup.