This user's frustration is entirely reasonable, and our position is clear: you should not have to manually patch a data gap that belongs to someone else's system. The problem described here isn't a spreadsheet skill gap, it's a broken data pipeline that has been quietly offloaded onto the person who actually needs the report to work. When a dealership name disappears between monthly reports because of an IT issue on the other company's side, the spreadsheet has become a liability, not a tool. The request is deceptively simple: use XLOOKUP to fill in blank cells from a prior report, but only when the cell is empty. That is technically possible, and it should not require a Reddit post to figure out.
What this user is really asking for is a way to make their spreadsheet smart enough to compensate for someone else's negligence. The monthly report arrives missing data that was present the previous month. Manually typing it back in wastes time and introduces errors. The next month, the same dealership names vanish again. The user wants a lookup that respects blank cells, overwrite nothing, fill only the gaps. That is exactly the kind of conditional logic that modern spreadsheet tools can handle, but the traditional approach requires nested IF statements or helper columns. The user already knows this. They are not asking for a miracle. They are asking for a method that stops treating the symptom and starts treating the cause.
The deeper issue here is that the user has accepted that the other company will not fix their export. That is a practical concession, not a defeat. It means the user is ready to build a resilient workflow that absorbs bad data without breaking. Instead of waiting for perfection upstream, they are designing a downstream fix that works every month. That is the right instinct. The spreadsheet should not be a passive container for whatever garbage arrives. It should be an active layer that reconciles, validates, and protects the user's time. This is where the conversation shifts from "can XLOOKUP do this" to "what else can your spreadsheet do when the source data is unreliable."
The solution is straightforward: use XLOOKUP inside an IF statement that checks whether the current cell is blank. If the cell is empty, pull the dealer name from the prior month's report. If it already has a value, leave it alone. That logic takes about ten seconds to write and saves hours of manual reconciliation every cycle. More importantly, it signals that the user is no longer willing to be the human patch for a system that refuses to improve. That is the real takeaway here. The technology is already capable. The only question is whether you are ready to stop working around bad data and start making your spreadsheet do the work for you.