The PivotTable modifications to reflect the new romantic relationship. Even so the PivotTable doesn’t seem appropriate very nevertheless, due to the ordering of fields inside the ROWS location.Queries a range or an array and returns an item corresponding into the initial match it finds. If a match will not exist, then XLOOKUP can return the�