Excel formula guides

Mid-tail how-tos, error fixes, and comparisons for real spreadsheet work—then jump to a free generator when you want a paste-ready formula.

• Why VLOOKUP returns #N/A (and how to fix it)

  Stop VLOOKUP #N/A fast: check exact match, data types, column index, and lookup range. Includes copy-paste examples for Excel and Google Sheets.

  Updated 2026-08-13·VLOOKUP formula generator

• VLOOKUP vs XLOOKUP: which one should you use?

  Compare VLOOKUP vs XLOOKUP with the same SKU example, version limits, left lookups, and if_not_found. Includes Excel and Google Sheets notes.

  Updated 2026-08-21·XLOOKUP formula generator

• XLOOKUP vs INDEX MATCH: which one should you use?

  Compare XLOOKUP vs INDEX MATCH with the same examples: last match, Excel 2019 left lookup, and non-adjacent returns. Includes Excel and Google Sheets notes.

  Updated 2026-08-21·XLOOKUP formula generator

• VLOOKUP vs INDEX MATCH: which one should you use?

  Compare VLOOKUP vs INDEX MATCH for Excel 2010–2019 files: when to keep VLOOKUP, when one MATCH should feed several INDEX formulas, and how that cuts recalc scans.

  Updated 2026-08-21·VLOOKUP formula generator