format will not work in this case because

来源: 天蝎 于 2011-08-05 15:33:09 [] [旧帖] [给我悄悄话] 阅读数 : (398 bytes)

it doesn't change the nature of the cell.  Hopefully we are talking about the same issue and you undersdand what I'm talking about...

1. Add a column next to the lookup_value and also the first cloumn of the table_array. 

2. Then use the clean function to clean up both 2 columns. 

3. Then use the vlookup targeting with the new columns.

所有跟帖： 

• Thank you very much and will try it tomorrow.Have a nice weekend -airsusan- ♀ 给 airsusan 发送悄悄话 airsusan 的博客首页 (0 bytes) () 08/05/2011 postreply 16:15:04

请您先登陆，再发跟帖！