Here's a problem that looks simple and turns out to be a trap. A user on Reddit builds a formula to find the cell holding the maximum value in a row. The formula runs without errors. It returns `$D$6`. And cell D6 is blank. That's not a bug. That's a lesson in how spreadsheets actually behave when we assume they work the way we think.
The culprit is the `MATCH` function with its third argument set to `0`, which asks for an exact match. When the range includes empty cells, `MATCH` treats a blank as a valid entry, specifically, it treats it as zero. If the maximum value in the row is positive, a blank cell is not the max. But if the maximum value is zero or negative, or if every other cell contains a number greater than zero, the blank cell can become the match. In this case, the user's data set likely has zeros or negative numbers elsewhere, or the blank cell is being treated as the lowest value that happens to equal the result of `MAX`. The formula is technically correct. It's just answering a question the user didn't intend to ask.
What this means for you is that spreadsheet functions are literal. They do not infer intent. `MAX` ignores blanks when calculating the largest number, but `MATCH` does not ignore them when looking for that number. The mismatch is invisible until you audit the result. The fix is straightforward: add a condition that excludes empty cells from the match. Wrapping the range in `IF` to filter out blanks, or using `INDEX` with `AGGREGATE`, forces the formula to only consider cells that actually contain data. The user's instinct to use `ADDRESS` and `MATCH` was sound. The oversight was assuming that blank cells are invisible to all functions equally.
This is the kind of moment that separates frustration from understanding. Spreadsheets are powerful, but they are also ruthlessly literal. They do what you say, not what you mean. The real skill isn't memorizing syntax, it's learning to ask the right question. The user's question was, "Which cell holds the maximum value?" The spreadsheet answered, "The cell that matches the maximum value, even if it's blank." The better question would have been, "Which non-empty cell holds the maximum value?" That shift in framing turns a dead end into a solvable problem. And that's the transformation worth pursuing: not a better formula, but a clearer question.