In the process of comparing two cells with text data, for example in a spreadsheet, the result may suggest a difference even when both strings contain the same content. A common reason for this is a difference in letter case used in these strings. Therefore, it is important to ensure that the strings are saved in the same letter case.
It's worth noting this issue because, although two words may have the same meaning, their representation using different letter cases can lead to different results in the comparison process.
For example:
result
Comparing strings using the LOOKUP/LOOKUPVALUE formula:
There are also situations where letter case doesn't matter. For example, when using the LOOKUP/LOOKUPVALUE formula, the spreadsheet treats strings as identical regardless of their letter case.
For example:
lookupvalue formula
result
0 Comments