Excel - Creating a search box and using the Filter formula to find data (exact match method)
How to create a search box, assigning a cell to it and then use of the "Filter" formula to return data.
Also, see the video for finding a partial match here:
• Excel - Partial match using the filter for...