See Allen Browne's FindAsUType routine. http://allenbrowne.com/

This routine is written for an Access database - but it is in VBA and can
probably be modified for Excel



"Scott Eslick" wrote:

it is possible to have the look up fill as you type instead of just have to
scroll through, i have over 5000 items in a lookup tab and it takes for
every. OR are there any other sugguestions on hpow to do this?