You can check the template for how INDEX formula enables the search function within the worksheet using a textbox. Download template with full access

(Password: jafarpp.in)