An asset export treats Kit-A and KIT-A as distinct identifiers. Compare their spelling and case before joining the records.

Keep a match and a case mismatch in the sample

Enter Kit-A in A2 and B2. In row 3, enter Kit-A and KIT-A. Fill =EXACT(A2,B2) down column C. The expected results are TRUE and FALSE.

Two worksheet rows yield TRUE for the identical case and FALSE for the uppercase variant.

Illustrated comparison. Keep both source codes beside the result.

Investigate a surprising FALSE

If both cells appear to say Kit-A, compare their lengths with LEN and read both in the formula bar. A trailing space gives six characters instead of five. Check the authoritative ID before trimming or changing case. Keep the raw identifiers beside the flags.

A trailing space makes an apparently identical code one character longer.

Illustrated invisible character check. Inspect the formula bar before normalizing.

Microsoft’s EXACT function reference