Array arguments to xlookup are of different size. – Array arguments to XLOOKUP must be of the same size. If they are not, an error message will occur. This can…