The PivotTable changes to mirror the new relationship. Though the PivotTable doesn’t seem proper quite nonetheless, as a result of ordering of fields from the ROWS location.Searches a range or an array and returns an item corresponding to the first match it finds. If a match does not exist, then XLOOKUP can return the closest (approximate)