When exporting QBO reports, eg. P&L, to EXCEL, what is the underlying formatting from QBO that doesn't allow for INDEX MATCH or VLOOKUP to work properly? Any Fixes? Thx

QuickBooks Online (QBO) is designed as a cloud-based accounting solution with its own structured, Paul.

When you export data from QBO as an Excel file, no formulas are included. Furthermore, QBO doesn't natively support complex Excel functions. When reports are exported, QBO applies its internal formatting. This can include non-standard or invisible characters like non-breaking spaces or Unicode formatting that aren't compatible with Excel's formula requirements.

I recommend seeking expert assistance from IT professionals and Excel specialists to address the formatting.

Let us know if you need assistance by clicking the Reply button.