Case-sensitive INDEX and MATCH?

Hi - Dave here. Happy New Year! By default, Excel is not case-sensitive. This means lookup functions like VLOOKUP, XLOOKUP, and INDEX and MATCH are also not case-sensitive. These functions will simply return the first match, ignoring case. How can we perform a case-sensitive lookup in Excel? One option is the EXACT function, which is designed to compare text values, respecting case. The worksheet below shows how EXACT can be used with INDEX and MATCH to solve the problem. The formula in G6 is: =INDEX(data,MATCH(TRUE,EXACT(F6,data[First]),0),3) which matches "JANET" in row 10 of the worksheet. [Example of case-sensitive INDEX and MATCH]( [[download the workbook and read the full explanation](] Like many advanced formulas in Excel, this approach requires you to imagine what the formula is doing, even though the process is largely invisible. There is no shortcut to mastering these ideas, you just have to practice :) Note: the workbook above also includes an XLOOKUP option. Excel formulas We maintain a large list of working formulas [here](. If you need more structure, we also offer [video training](. Have a fun and safe weekend! Dave [View email in browser]( [Exceljet Logo]( Exceljet P.O. Box 4804 Salt Lake City, UT 84110 Copyright © 2021 Exceljet, All rights reserved. You received this email because you are subscribed to our newsletter. To unsubscribe, click the link below. [Unsubscribe](