Excel 7 min read Build a dynamic dashboard with XLOOKUP and one drop-down One drop-down cell, four XLOOKUP formulas, and every number on the dashboard updates itself - no PivotTable, no slicer, no VBA in sight. 14 July 2026