14:58
2026-08-05
codenote.net
developer-tools
Choosing Portable Functions for Spreadsheets Shared Between Excel and Google Sheets — Replacing XLOOKUP with SUMIF for Compatibility
Tadashi Shigeoka reports that XLOOKUP formulas written in Microsoft Excel can return empty or incorrect results when the .xlsx file is opened in Google Sheets, and recommends replacing XLOOKUP with SU…