In this thread, we have created a User Form to search efficiently through a sheet with data. We have used Advanced Filter and formulas to ensure that the performance is good.

Attached is a worksheet with the Search Tool.

Search_Tool.zip