the lookup_value and the first column of table_array

Should both be number or both be text.  Here is the note from Excel Help:

• When searching text values in the first column of table_array, ensure that the data in the first column of table_array does not contain leading spaces, trailing spaces, inconsistent use of straight ( ' or " ) and curly ( ‘ or “) quotation marks, or nonprinting characters. In these cases, VLOOKUP might return an incorrect or unexpected value. 

You can use either CLEAN function or TRIM function to clean the data up.

所有跟帖： 

• I formated the value both in the same format but it still could -airsusan- ♀ (66 bytes) () 08/05/2011 postreply 15:21:52

• format will not work in this case because -天蝎- ♀ (398 bytes) () 08/05/2011 postreply 15:33:09

• Thank you very much and will try it tomorrow.Have a nice weekend -airsusan- ♀ (0 bytes) () 08/05/2011 postreply 16:15:04