Two rows look like “AV Room,” but a match misses one of them. Check the space after AV. A nonbreaking space looks ordinary and has a different code point.
Read the suspect character by position
Put the imported text in A2. Its third character is the space. Ask the sheet for that character’s code point:
=UNICODE(MID(A2,3,1))A result of 160 is a nonbreaking space. An ordinary space is 32.

Illustrated diagnosis. Inspect the exact character position.
Clean a separate column and run the original match again
In B2, replace all occurrences of that specific nonbreaking space with an ordinary space.
=SUBSTITUTE(A2,UNICHAR(160)," ")Run the same character check on B2. It should return 32 for the third position. Then rerun the lookup with the cleaned label. If it still misses, compare the remaining characters and the other lookup input.

Illustrated verification. Compare both the visible label and its code point.



