If you are still building store reports with XLOOKUP, you are working harder than you need to. That file you reference every day, with new stores, old stores, projected openings, and constantly changing square footage, it is a perfect candidate for a more intelligent system. The real problem is not the lookup function itself. It is the maintenance. Every renovation, every closure, every update to a store's details forces you to revisit a fragile web of formulas. That is not sophisticated. It is brittle.
The core issue here is that your data is alive, but your tool is treating it like it is dead. A spreadsheet built on lookups assumes that your source table is static. The moment you add a row, delete a column, or change a store name, your carefully crafted formulas break or return stale results. You need a setup where the data lives in a single, editable source and every report pulls from it automatically. An AI-native spreadsheet can do exactly that: it treats your store listing not as a lookup table but as a living, queryable database. You type a store name, and the details appear, no formulas, no broken references, no manual recalculations. And when a store undergoes renovation, you update one record, and every report tied to it updates instantly.
This is not about replacing your current file. It is about upgrading how you interact with it. The sophistication you want comes from eliminating the middleman, the lookup, and letting the tool understand the relationships in your data. A user should be able to walk in, change the square footage for Store 42, and walk out. No one should have to trace dependencies or wonder if the formula range includes the new row. That is what accessible, human-centered design looks like in practice. It empowers the person who knows the data best to maintain it without needing to be a spreadsheet expert.
Our take is plain: stop using XLOOKUP for data that changes. Move to a system where the data and the logic are one and the same. Your store list is not a reference file, it is your source of truth. Treat it like one.