XLOOKUP: should a missing match be blank, zero or a warning?
Picture a price sheet with a genuine free item and a product ID that no one has entered yet. If both come back as zero, the next person…
Read guide →CELLLINGO LEARNING LIBRARY
Spreadsheet Guides
Practical articles focused on formulas, data cleanup and workbook handoffs.
Read a long Excel formula one piece at a time
A formula spanning three lines can feel like a wall of punctuation. The trick is to stop reading it left to right. Find the decision at the outside,…
Read guide →