Excel XLOOKUP Function
Oh, how I wish I’d had the fortune of the new Excel XLOOKUP function back in my accounting days. The first powerful function I learnt was VLOOKUP. It gave me a sense of power and cemented my love of Excel. XLOOKUP is everything VLOOKUP is and much more. XLOOKUP can look up to the left …