There is a smarter way to solve this problem than the one YouTube is failing to provide. The real issue isn't a missing formula, it's that traditional spreadsheets were never designed to track data that moves.
The F1 fan who posted this knows exactly what they want: a combined standings view that pulls from three separate tables, actual points, reserve points, and qualifying points. The obstacle is that drivers and teams shift rows as their totals change across the season. A simple SUM won't work because the data isn't static. This is a common frustration that spreadsheet users encounter when they ask data to behave like a living system instead of a fixed grid. The conventional tools treat every cell like a brick in a wall. Move one brick, and the whole structure breaks.
What this user actually needs is a way to reference data by identity rather than by position. You do not want to add the value in row 7. You want to add the value that belongs to Lewis Hamilton, wherever his row happens to be this week. That is a fundamentally different request, and it requires a tool that understands entities, not just coordinates. AI-native spreadsheets are built for exactly this kind of thinking. They can match a driver's name across shifting tables, retrieve the correct points from each category, and assemble a unified view that updates automatically when the standings change. The user's request is not exotic. It is a straightforward data transformation that legacy tools simply never prioritized.
The practical takeaway is this: if you are building a multi-table tracker and hitting the same wall, stop searching for the right formula in a tool that was designed for accounting ledgers in 1982. Look for a solution that treats your data as connected records, not as arranged cells. The combined standings view is not a workaround. It is the standard that your workflow deserves.