Forum Discussion
Excel Problem on WINDOWS
AndreanMiky When you break down the text strings to their individual character codes, you'll see that the strings in Sheet1 contain regular spaces (character code 32) whereas the strings on Sheet2 contain non-breaking spaces (code 160 on the PC, code 202 on the Mac).
Now the odd thing is that Excel for Mac considers code 32 to be equal to code 202. Hence, XLOOKUP finds a match and returns a value. Excel for PC, however, does not consider code 32 to be equal to code 160, and XLOOKUP correctly returns #N/A. Can't really explain why Excel is behaving like this on the Mac.
Dear ExcelExciting Attached
AndreanMiky When you break down the text strings to their individual character codes, you'll see that the strings in Sheet1 contain regular spaces (character code 32) whereas the strings on Sheet2 contain non-breaking spaces (code 160 on the PC, code 202 on the Mac).
Now the odd thing is that Excel for Mac considers code 32 to be equal to code 202. Hence, XLOOKUP finds a match and returns a value. Excel for PC, however, does not consider code 32 to be equal to code 160, and XLOOKUP correctly returns #N/A. Can't really explain why Excel is behaving like this on the Mac.
- thank you Pak
- This is great information and new to me.. thanks for sharing it !!
