What is the most common cause of a lookup failing on values that look identical?
- A Invisible leading or trailing whitespace
- B Different fonts
- C Case sensitivity only
- D File encoding
Answer
Invisible leading or trailing whitespace
Trimming whitespace and normalising case should be standard steps before any join or lookup on text keys.





