Microsoft Excel’s XLOOKUP function is a powerful tool for finding data in a table or range. When…