How does XLOOKUP work, and what is the key rule of VLOOKUP? SUMIF, IF, PivotTable and Flash Fill: 6 Excel tools that make everyday work easier.