Find a matching value case sensitive

blank

Case Sensitive

You can use the LOOKUP function to compare values to find an exact match, but the match is not case-sensitive.
To accomplish a case sensitive lookup you can combine the LOOKUP function with the IF and EXACT functions.
There are a number of ways to do this:


HLOOKUP and EXACT

=IF(EXACT("better",HLOOKUP("better",Table_Range,1)) = TRUE, "found", "not found")


LOOKUP and EXACT

=IF(EXACT("better",LOOKUP("better",Table_Range,1)) = TRUE, "found", "not found")


VLOOKUP and EXACT

=IF(EXACT("better",VLOOKUP("better",Table_Range,1)) = TRUE, "found", "not found")


INDEX, MATCH and EXACT

=IF(EXACT("better",INDEX(Table_Range,MATCH("better",Table_Range,0), 1) = TRUE, "found", "not found")



© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top