Smart Search for Google Sheets™ unlocks powerful search capabilities directly within your spreadsheet. Go beyond basic find-and-replace with advanced operators that let you filter and navigate your data instantly.

Key Features:

    Smart Lookup: Opens a fast, filterable table view of your entire sheet to quickly find and jump to any row.

    Smart Search (Navigation): Instantly filter the rows in your current sheet view based on complex search queries.

    Custom Search Logic: Define your own AND, OR, and SEPARATOR operators for flexible searching across multiple columns.

    One-Click Navigation: Click any result in the Smart Lookup table to be taken directly to that row in your sheet.

    Persistent Preferences: Your custom operator settings are saved per sheet using Google's secure Properties Service.

How It Works: Simply install the add-on and access "Smart Lookup" or "Smart Search" from the Extensions menu. Use the custom search box with your operators to filter data in real-time. All processing happens locally within Google's secure environment—your data never leaves your spreadsheet

Perfect for managing large inventories, contact lists, project data, or any complex spreadsheet where finding information quickly is essential.

Google Sheets™ is a trademark of Google LLC.