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

Also known as a Comma Separated Value file, a comma delimited file is a standard file type that a number of different data-manipulation programs can read and understand, including Microsoft Excel.

Microsoft Excel's new dynamic array functions make complex calculations easier than ever before.