If your Excel reports keep breaking every time you add new data, the problem probably isn’t Excel, it’s how the report is built.

VLOOKUP and XLOOKUP aren’t bad formulas, but they’re the wrong tool for recurring reports. Copying formulas down duplicates data…