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")