How to use VLOOKUP to look for Chinese characters?

[tatarik]

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.

 

[DILIPandey]

Hi Tatarik,

I guess there is no limitation with Chinese font as long as the character is same.
Cross check the character in both the table using equal to "=" operator or using Exact function.


Also, in sheet 1 you are referring columns from B to AA when you need results from column 2 - any specific reason? Thanks.


Regards,
DILIPandey

 

[pgc01]

Hi tatarik
Welcome to the board

Can you post examples, so that we can test?

 

[tatarik]

Thanks for your reply DILIPandey

I guess there is no limitation with Chinese font as long as the character is same.
Cross check the character in both the table using equal to "=" operator or using Exact function.

I just did your test and realized that a space was in the target column. After a cleanup, the formula finally worked !
I feel a little stupid to have posted such a lame question, but gratitude for your support

Thanks pgc01 too, I think I'm good

T.

 

[DILIPandey]

You are welcome Tatarik... Cheers



Regards,
DILIPandey