I need to be able to allow users to type a last name in a column (A) that I
have setup as a list feature. Currently the only option is to scroll through
the entire list, I'd rather allow them to begin typing a last name and have
the list go to the last name as they type. Can this be done in a list?

For instance, in cell A2 they find the last name (by scrolling the list)
then select the last name and by using a VLOOKUP function it places the first
name (cell B2), MI (cell C2) and ID# in (cell D2).

Thanks,
Mike