Can I lookup my Primary Key in SQL Server from Excel Spreadsheet?
Yes, Excel can query data from a database. On the Data tab there are tools to create and maintain connections. IIRC it uses ODBC so all major database products can be referenced.