You might like to think about using a combo box, as this has auto-
complete. Debra Dalgleish takes you through it he

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

Hope this helps.

Pete

On Sep 30, 2:11*pm, Aligahk06
wrote:
Dear All,

In data validation we have more than 5000 lists and their corresponding
records.

Looking an item *in the list manually is quite trouble and scrolling *upto
5000 lists is tedious.
Can i have a technique that we can find our list either by serching or
finding techniques once a
particular item list is looked.

Please assist ?

Rgds,

Alighak06