The spreadsheet user who posted this question is not asking for help with a clever formula. They are asking for permission to stop fighting the tool. Their problem, tracking repeated ID results across call logs, is a textbook case of a data structure that Excel was never designed to handle well, yet millions of people try to force it to work every day. The real story here is not about VLOOKUP limitations or inconsistent ID lengths. It is about the gap between what users need and what legacy spreadsheet tools can deliver, and the quiet frustration that fills that gap.
This user has already done the hard work. They identified the core requirement: knowing whether each person has ever received a voicemail, hung up, or asked for a call back. They correctly recognized that VLOOKUP only returns the first match. They attempted creative workarounds, concatenating ID and result, nesting IF and AND statements, but each attempt revealed a deeper limitation. Their final constraint is telling: no VBA, no Power Query, no macros. They need a solution their boss can paste data into and get results from immediately. That is not a technical preference. That is a business requirement for accessibility and repeatability.
The practical answer to this problem is not a better Excel formula. It is a pivot table, or better yet, a simple COUNTIFS function that checks for the co-occurrence of ID and result in the same row. But even that solution only papers over the underlying issue: the user is asking a relational question, "which IDs have which outcomes?", and trying to answer it in a flat, row-by-row environment. Every workaround they tried was an attempt to make Excel behave like a database. And Excel, for all its power, is not a database. The user is not failing at Excel. They are succeeding at understanding their data problem, but the tool is failing them.
Our take is clear: when your data has repeating identifiers and you need to ask questions about patterns across those repeats, it is time to stop optimizing for the tool and start choosing the right tool. An AI-native spreadsheet that understands relationships the way a user does would let this person ask "show me all IDs that have both 'Hang up' and 'Voicemail'" and get the answer instantly, without formulas, without concatenation, and without a manual documentation process for their boss. The frustration this user feels is not a skill gap. It is a product gap. And the solution is not to learn more Excel tricks, it is to explore a spreadsheet that works the way your thinking does.