Concatenate values with the “&” operator and using wildcards in XLOOKUP
ntroduction: XLOOKUP is a new and powerful function in Excel that was introduced in Excel 365. It is similar to the VLOOKUP function, but it offers some additional and advanced…