How to use the newish XLOOKUP() dynamic array function in Excel

Microsoft Excel’s dynamic array function XLOOKUP() might completely replace VLOOKUP() and HLOOKUP().