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

請您先登陸，再發跟帖！