To create a search field in a spreadsheet, you must first activate the Developer tools menu. To do this, go to Options > ...

You could create something more sophisticated with LOOKUP functions, but they were a huge hassle to set up. Not anymore: Excel 2013’s table tools include features that make it easy to link ...