¥»©«³Ì«á¥Ñ sax868 ©ó 2012-5-8 23:05 ½s¿è
Book1.zip (6.75 KB)
¦U¦ì¤j¤j±ß¦w!
¦pªþ¥ó¡C½Ð°Ý§Ú¥Î¨âÓ¨ç¼Æ¤À¶}¼g ¦A§â²Ä¤@Ó=LEFT(B3,7)½Æ»s¡B¶K¤W¥BÂà´«¦¨¼Æ¦r«h²Ä¤GÓ¨ç¼ÆÈvlookup ´N¦³µª®×,¦ý¬O·í§Ú§â¨âÓ¨ç¼Æ¼g¦b¤@°_®É(^=VLOOKUP(LEFT(B2,7),Vlookup!A:B,2,FALSE)«ç»ò´N¥X²{#N/A¤F©O??(§ï³q¥Î/¼Æ¦r/¤å¦r³£¨S¦³¥Î...)
«ô°U³Â·Ð½Ð°ª¤â±Ï§Ú³oÓ§b¥Ê...ÁÂÁÂ!!:'(
®z¤k¤l¯d |