Spreadsheet Weekly

Excel tutorial library

Step-by-step fixes for the Excel problems that come up at work, each with a practice file.

  1. Why XLOOKUP says #N/A when the value is right there

    Three invisible causes, how to spot each in 10 seconds, and one formula that handles all of them.