Is there any one who is very good at excel vlookup function? Hel

來源: airsusan 於 2011-08-05 14:40:42 [] [博客] [舊帖] [給我悄悄話] 閱讀數 : (244 bytes)

I am working on one work book and use vlookup function to find values but the vlookup does not work. I have format both value at the same format but it just can not work. Any other suggestions to check the formular. Thanks

 

所有跟帖： 

• the lookup_value and the first column of table_array -天蠍- ♀ 給 天蠍 發送悄悄話 (1074 bytes) () 08/05/2011 postreply 15:13:53

• I formated the value both in the same format but it still could -airsusan- ♀ 給 airsusan 發送悄悄話 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- ♀ 給 airsusan 發送悄悄話 airsusan 的博客首頁 (0 bytes) () 08/05/2011 postreply 16:15:04

• I never use vlookup but index/match function -highage- ♂ 給 highage 發送悄悄話 highage 的博客首頁 (0 bytes) () 08/06/2011 postreply 21:57:10

請您先登陸，再發跟帖！