XLOOKUP vs VLOOKUP: what actually changes in your work
VLOOKUP has three structural weaknesses that cause most lookup errors. XLOOKUP removes all three — here is exactly how, and what to do when your Excel version does not have it.
A dashboard that is technically correct and never opened has failed. Here are the six reasons that account for most of them, in roughly the order of how often we see them.
Twelve charts, all the same size, evenly spaced. Nothing tells the reader what matters. A viewer's eye starts top-left, so the single most important number belongs there, physically larger than everything else. Secondary detail goes below and to the right. If everything is equally prominent, nothing is.
"Revenue: €1.28M". Is that good? Nobody can say. A number alone carries no information about performance — only a comparison does. Add at least one of: the same period last year, the target, the previous period, or a running average. A figure with a "▲ 12.4% vs last year" beside it answers the question the reader actually has.
Six colours because there are six categories, chosen from the default palette, changing between charts. Colour is expensive attention — spend it deliberately. Grey for context, one accent for the thing that matters, and semantic colour (red/green) reserved strictly for good and bad. Never encode the same category in different colours on different charts of the same dashboard.
Pie charts for anything with more than three slices — humans compare angles badly. Stacked area charts for trends, where every series except the bottom one is impossible to read because its baseline moves. Dual axes, which can be made to show almost any relationship you like by choosing the scales. When in doubt, a bar chart for comparison and a line chart for time will serve you better than anything clever.
Dashboards accumulate. Someone asks for one more metric, it gets added, and nothing is ever removed. Within a year the page has thirty numbers and no message. Ask of every element: which decision does this change? If nothing changes, it belongs in a detail report, not on the dashboard.
The person who built it can always read it. That proves nothing. Put it in front of the intended audience without narrating, and ask two questions: what do you think this is telling you, and what would you do next? The confusion in the first thirty seconds is the most valuable design feedback available, and it costs nothing.
Show the dashboard for five seconds, then hide it, and ask what the reader remembers. If the answer is the main message, the hierarchy works. If the answer is "there were a lot of charts", it does not — and no amount of additional detail will fix it.
VLOOKUP has three structural weaknesses that cause most lookup errors. XLOOKUP removes all three — here is exactly how, and what to do when your Excel version does not have it.
The single highest-return change most Excel users can make. A worked example, the mistakes that make queries fragile, and how to build one that survives next month.
Sales says 4,120 active customers. Finance says 3,880. Both are right. The problem is not the data — it is that nobody wrote down what "active" means.