The problem described here isn't a bug; it's the sound of a tool hitting its limits. When a user types `=VLOOKUP(C5,database!A1:database!B24,1)` and gets an exclamation mark instead of the expected result, the instinct is to blame the formula. But the real failure isn't in the syntax, it's in the architecture. VLOOKUP is a legacy function designed for static, single-sheet lookups. It struggles when data spans multiple sheets, when the lookup value lives in a different context, or when the table array isn't perfectly aligned. The exclamation mark is not an error code; it's a signal that the spreadsheet is asking the user to do something the tool was never built to handle.
For the user who painstakingly checked that `C5`, `A14`, and `B14` all return type "2" (text), and verified that "b" exists in column A, the frustration is real. The formula is technically correct by the old rules. Yet it fails because VLOOKUP expects a contiguous range on a single sheet, not a cross-sheet reference formatted as `database!A1:database!B24`. That extra sheet qualifier breaks the implicit assumption that the table array is flat. The tool doesn't give a helpful error message, it just spits out an exclamation mark, leaving the user to hunt through forums with no answers. This is the moment when a user realizes that the spreadsheet they rely on is no longer a partner but a gatekeeper.
What this means for you is straightforward: if you are spending time debugging lookup functions that should be simple, you are not the problem. The tool is. Spreadsheets were designed for a world where data lived in one place, in one format, and never grew beyond a few hundred rows. Today, your data comes from multiple sheets, databases, and live feeds. A function that cannot handle a simple cross-sheet reference without breaking is not a tool for modern work. It is a relic.
Our take is clear: stop treating the symptom and address the cause. The exclamation mark is an invitation to look deeper, not into the formula, but into the tool itself. AI-native spreadsheets do not require you to debug table arrays or guess why a cross-sheet lookup fails. They understand context, resolve references automatically, and tell you what went wrong in plain language. You should not have to search the internet for why a basic lookup returns "!". You should be able to ask your spreadsheet, "What happened here?" and get a clear answer. That is not a future feature. It is the baseline for a tool that respects your time.