Excel Drop Down List - typing first letter selects matching names in the Lookup range

I have created a simple Dropdown List in an input cell in spreadsheet 1 of a workbook that references a lookup range on spreadsheet 2 within the same workbook.  This is to ensure correct data validat...