Excel Keyword Filter Box

I need a slick, self-contained search box in an existing Excel workbook that relies solely on formulas—no VBA at all. The data you’ll be targeting is plain text stored in a single table. When I type a keyword (or partial keyword) into the search field, the worksheet should immediately filter that table so only matching rows remain visible, restoring the full list when the box is cleared.

You’re free to use modern 365 functions such as FILTER, SEARCH, LET, etc., or classic combinations if you prefer, as long as the experience feels instant and intuitive. The layout must stay tidy: the search field, any helper formulas, and the dynamic results all on the same sheet.

Deliverables
• A working workbook (or template) with the formula-driven search box implemented
• Clear in-cell comments or a short note sheet explaining how to maintain or adapt the formulas

Once I confirm everything runs smoothly, the job is done. I’m ready to get started right away.