Hello everyone,
I have tried to use VLOOKUP to search for a set of 1 or more than 1 Chinese characters (ex: 我们) in another table (Sheet1).
My formula: =VLOOKUP($A10,Sheet1!$B$1:$AA$109056,2,FALSE)
I have very inconsistent results. For some words I definitely know there is a match, I still get #N/A.
Is there any limitation to use VLOOKUP to look for Chinese characters?
Thanks in advance for your help
T.
I have tried to use VLOOKUP to search for a set of 1 or more than 1 Chinese characters (ex: 我们) in another table (Sheet1).
My formula: =VLOOKUP($A10,Sheet1!$B$1:$AA$109056,2,FALSE)
I have very inconsistent results. For some words I definitely know there is a match, I still get #N/A.
Is there any limitation to use VLOOKUP to look for Chinese characters?

Thanks in advance for your help

T.