Japanese version. The VLOOKUP and XLOOKUP functions ignore case when searching. Therefore, the intended result may not be obtained. Here is how to solve that problem. Steps IF, SUMPRODUCT, EXACT, INDEX, and ROW functions are used. The cell range must be specified starting with the first row. This will result in a case-sensitive search. If the LET function is available. The LET function can be used to exclude duplicate cell designations in the search range. This saves time and reduces the risk of making a mistake when changing reference cells. Links Tips. XLOOKUP & VLOOKUP & HLOOKUP(Microsoft Excel)