A deadline, an absent boss, and a function that refuses to behave as expected, nearly every spreadsheet user has faced that moment. The user, let's call her the original poster, needs to identify new accounts since last month. She turns to MATCH, a logical lookup. Instead of a clean error or a true/false signal, she gets a dollar amount. The immediate instinct is frustration, but the real issue here is not a broken formula. It is a mismatch between what she *asked* the spreadsheet to do and what she needs it to *tell* her.
MATCH is a position finder. It returns a number, the row or column index where a value lives. A dollar sign in the result often indicates a formatting artifact or a cell reference that pulled in a currency style from the source data. The function is working exactly as designed. The problem is that a position number is not the yes/no answer she needs for a simple audit. She wants a binary check: "Is this account new?" MATCH gives a coordinate, not a verdict. The practical fix is straightforward: wrap MATCH inside ISNA, or use COUNTIF with a zero-length string check. But the deeper lesson is about tool selection. A lookup function is for location. A logical test is for existence.
We think this scenario reveals a common trap in spreadsheet work. Users often reach for the most familiar function rather than the most appropriate one. MATCH is powerful, but it was built for dynamic lookups, not for binary checks on a list. The original poster's boss is unavailable, and that pressure can push anyone toward a quick, familiar solution. We have all been there. The better approach is to step back and ask: *What shape should the answer take?* A list of new accounts needs a column of flags, TRUE/FALSE, 1/0, or "New"/blank. MATCH alone cannot produce that. Pair it with ISNA, and suddenly the output becomes a clean, readable column that a boss can scan in seconds.
The concrete takeaway here is simple: before you type a formula, decide what your output should *look like*. Do you need a number, a label, or a yes/no? If the answer is yes/no, reach for a logical function first, ISNA, COUNTIF, or even a simple IF with a comparison. MATCH is the wrong tool for that job, and the dollar sign was a clue, not a bug. Next week, when the boss returns, the original poster will have a much better conversation if she can say, "I found the new accounts using a logical check, and here is the list." That is the kind of outcome that builds confidence, hers and her boss's.