ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

vlookupªº°ÝÃD (¤w¸Ñ¨M)

vlookupªº°ÝÃD (¤w¸Ñ¨M)

¥»©«³Ì«á¥Ñ trainee ©ó 2012-4-4 10:16 ½s¿è

·s¤B©ó³B²zvlookup®É¡A¹J¨ìºÃÃø¡A
·Ð½Ð¦U¤j¤j½ç±Ð¡I
vlookupªº°ÝÃD.rar (1.71 KB)

¦^´_ 1# trainee

¤£¤Ó¤F¸Ñ ³o¼Ë¥i¥H¶Ü?
B2=IF(OR(B1="",A2=""),"",VLOOKUP(A2,{1,2;2,3;3,4;4,5;5,6},2,FALSE))

TOP

¦^´_ 1# trainee

B2=IF(B1="","",VLOOKUP(LOOKUP(10,$A$2:A2),{1,2;2,3;3,4;4,5;5,6},2,FALSE))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# register313

¥ý·PÁ¤j¤jªº½çÂФΫü¾É¡I

«Ü©êºp¡I¦]§Ú¨S¦³ªí¹F²M·¡¡A®ö¶O¤F¤j¤jªº®É¶¡¡I
­YA¦CªºÀx¦s®æ¤º¸ê®Æ¡A
©ó±µÄò¤@¦C(§YB¦C)¤º¬Û¦P¦ì¸mªºÀx¦s®æ¡A
§Y¶·°Ñ·Ó¦P¤@¦C¡A«e¤@«DªÅ¥ÕÀx¦s®æ¤ºªº¸ê®Æ¡A
¥HVLOOKUP³o¨ç¼Æ±a¤J¸ê®Æ¡I
¦ýªÅ¥ÕÄæ¼Æ¶q«D©T©w¡A¦³®É3Äæ¡A¦³®É4-5Äæ¡I

TOP

¦^´_ 3# Hsieh

¥ý·PÁÂHsieh¤j¤jªº½çÂСI
·s¤B¸Õ¸Õ¡I

TOP

¦^´_ 3# Hsieh

¦A¦¸Á¹LHsieh¤j¤j¡A
·s¤BªººÃÃø¸Ñ¨M¤F¡I
·s¤B©|­n¦n¦n°Ñ¸Ô¡I

TOP

        ÀR«ä¦Û¦b : ­n¥Î¤ß¡A¤£­n¾Þ¤ß¡B·Ð¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD