Is Xlookup Case Sensitive?
The XLOOKUP function isn’t sensitive to cases. The upper case and the lower case characters are the same. The EXACT function can be used to perform a case sensitive look up. Is A VLOOKUP case-sensitive or not? A lot of people don’t know that the VLOOKUP is case-insensitive, meaning it treats the same letters differently. … Read more