Sheet Navi
Five tools that replace complex formulas with smart, automatic behaviors.
Multilookup
A smart 2D lookup engine. Replaces INDEX/MATCH and VLOOKUP — works vertically, horizontally, or at the exact intersection of both.
Super VLOOKUP
Horizontal Filter
2D Matrix Search
Wildcard Search
Color Search Functions
Extract hex codes from any cell's background or font color. Use colors as logic — count, sum, or filter by visual formatting. Works with conditional formatting.
| Formula | Returns |
|---|---|
=CELLCOLOR("A1", Sync) | Background hex code (e.g. #306806) |
=TEXTCOLOR("A1", Sync) | Font hex code of the cell |
=CELLCOLORMATCH("B2:B10", "A1", Sync) | 1 if background matches A1's color, 0 if not |
=TEXTCOLORMATCH("B2:B10", "A1", Sync) | Same, but checks text color |
Set a color reference cell
Fill cell A1 with the color you want to match against (your "target" color).
Generate a match map
In C2: =CELLCOLORMATCH("B2:B10", "A1", Sync) — spills a column of 1s and 0s for each row.
Sum or count by color
=SUMPRODUCT(B2:B10, CELLCOLORMATCH("B2:B10", "A1", Sync)) — sums all values where the row color matches.
=CELLCOLOR("A1", Sync) ✓ =CELLCOLOR(A1, Sync) ✗
Auto-Sort — The Infinite Watcher
A background engine that keeps your data sorted continuously. Set it up once, and it silently snaps rows into order the moment you finish entering data.
Select your data range
Highlight the rows to manage — start from Row 2, skip headers. Including headers will sort them into the middle of your data.
Set Primary Sort
Type the column letter for your main sort (e.g. A). Choose YES for A→Z or NO for Z→A.
Set Secondary Sort (optional)
Enter a second column letter (e.g. B) to break ties. Leave blank to skip.
Define the Trigger Rule
Enter which columns must be filled before sorting fires (e.g. A, C). Prevents the sheet from jumping mid-row while you're still typing.
Type date in A → nothing · Type name in B → nothing · Type price in C → sort fires instantly.
Multi-Level Dependent Dropdowns
A chain of dropdowns where each level filters based on the previous selection. Select "Electronics" and only Electronics sub-categories appear — automatically.
Prepare your source table
Create a flat table with one column per dropdown level. Headers in Row 1. One row per combination — no merged cells.
| Category | Sub-Category | Product |
|---|---|---|
| Fruit | Apple | Honeycrisp |
| Fruit | Apple | Granny Smith |
| Fruit | Berry | Strawberry |
| Veggie | Leafy | Spinach |
Run the setup
Highlight the source table (including headers), launch multileveldropdown(), and follow the prompts to assign each level to a cell:
"Cell for Category?" → E2 · "Cell for Sub-Category?" → F2 · "Cell for Product?" → G2
It manages itself
Select a Level 1 value. Downstream cells immediately clear and show ⚠️ Select [Previous] until filled in order. Options are filtered, deduplicated, and sorted automatically.
