The PivotTable variations to mirror the new marriage. However the PivotTable doesn’t seem proper very still, because of the ordering of fields during the ROWS region.Searches a spread or an array and returns an item corresponding for the very first match it finds. If a match does not exist, then XLOOKUP can return the closest (approximate)