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.

The third character of a sample AV Room label looks like a space but returns Unicode code point 160.

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.

After substitution, the third character returns 32 and the cleaned label still reads AV Room.

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

Microsoft’s Excel function reference