If you’d like to learn about XLOOKUP(), read How to use the newish XLOOKUP() dynamic array function in Excel. I’m using Microsoft 365 on a Windows 10 64-bit system. Excel’s XLOOKUP ...

Along the way, you’ll learn several different ways to enter formulas and functions in Excel. We’ll demonstrate using Excel for Windows under a Microsoft 365 subscription.