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

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- ♀ (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

• I never use vlookup but index/match function -highage- ♂ (0 bytes) () 08/06/2011 postreply 21:57:10