Choosing Portable Functions for Spreadsheets Shared Between Excel and Google Sheets — Replacing XLOOKUP with SUMIF for Compatibility

When you author spreadsheets locally in Excel but share them via Google Sheets, function compatibility becomes a real operational bottleneck. This post covers a case where XLOOKUP broke on Google Sheets import, and the SUMIF / INDEX+MATCH replacements plus reconciliation cells that make sheets survive the round trip.

Google Sheets Data Validation that only allows null string or 1 ~ 100

A Google Sheets custom validation combining OR / AND / ISNUMBER / GTE / LTE to allow only 1-100 or a null string.

[Google Spreadsheet] To convert numbers to Plain Text, use the TEXT(A1,"@") function

When VLOOKUP fails unexpectedly, TEXT(A1,"@") to convert the key to plain text solved it.