In essence, XLOOKUP enables you to search a range or array based on a specified search value and return an associated value in a different column or row. For ...