Create a Search Box in Google Sheets

I really wanted to create a search box in Google Sheets. It's relatively easy to use Query, but how could I make a search box?

I finally found this post at Sheetaki and it creates exactly what I wanted to do! Typical query language is

= QUERY (some set of data, “Select * Where A ends with ‘XYZ’ “