Check not just the data type, but for preceding and trailing spaces and/or non-printing characters.

These are often issue when importing data from external database/model.

Other than that, consider building data model with relationships and use pivot table(s) to report on the data.