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

¨D¸ÑÃD vlookup: ¦p¦ó°µ¹ï¤ñ«áRETURN¥¿½TªºVALUE (¤ºªþ¹Ïªí¹Ï)

¨D¸ÑÃD vlookup: ¦p¦ó°µ¹ï¤ñ«áRETURN¥¿½TªºVALUE (¤ºªþ¹Ïªí¹Ï)

¤j®a¦n, ·s¤â¤u§@¤WªºEXCEL ÃøÃD! ½Ð¦U¦ì°ª¤âÀ°À°¦£,¨D¸ÑÃD


ÃøÃD¤@:­º¥ý­n¹ï¤ñ(C¦C)¨ÑÀ³¸ê®Æ®w¼Æ¶q¬O§_­q³æ¼Æ¶q(G¦C)
ÃøÃD¤G: ·QVLOOKUP ¥¿½T¤é¤l, ¨ì´Á¤é¤l(H¦C)¥u¥i¦³¤@­Ó´Á( ¨¬°÷¼Æ¶q©M³Ìªñ´Á¨º­Ó¤é¤l·|³Q¿ï)

§Ú¥u·Q¨ì¦bH5 ¼g¤F³o =IF(VLOOKUP(F5,A4:C10,3,0)>G5,VLOOKUP(F5,A5:C10,2,0),"*")


¨º­Ó[VALUE_IF_FALSE]³¡¤À, §Ú¥´* ¦ì´N¬O¤£·|¼gªº³¡¤À
¨º­Ó [VALUE_IF_TRUE]³¡¤À, VLOOKUP(F5,A5:C10,2,0), ¨ä¹ê§Úı±o³£¦³ÂI¤£¹ï /_\"

»Ý­n¥Î¨ìVBA ¶Ü?

¦^´_ 1# meii715


   
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

ÁÂÁ®v¥S¤À¨É!! ©ú¥Õ! ¾Ç¦h¥ª1­ÓMIN FUNCTION :D!

¨ä¹ê§Ú¤§«e³£·Q¤F­Óformulate, °µ±o¨ì ¥X¨ì¹ïµª®×  ¹Ï¦p¤U


¦ý´N¤£ª¾¬°¦ó©Ô¤U¥h¥k¤W¨¤·|¥X²{ºñ¦â¤u¨¤§Î (¦bcell H6) ¤£ª¾¹D¬Æ»ò­ì¦], ¬O¿ù»~ÁÙ¬O¤½¦¡¿ù¤F?
§Ú¸Õ¤F®v¥S´£¨Ñªº¤½¦¡,¦n¹³¨S¦³³o°ÝÃD, ¬O§Ú¤½¦¡Å޿襬°ÝÃD¶Ü?
¥i¥HÀ°§Ú¬Ý¬Ý¶Ü?
checking.rar (3.65 KB)

TOP

¦^´_ 3# meii715
¦]¬°§Aªº½d³ò°Ñ·Ó¨Ï¥Î¬Û¹ï°Ñ·Ó
©Ò¥H·í¤½¦¡¤U©Ô½Æ»s®É¡A¦C¸¹±N·|§ïÅÜ¡A³y¦¨¤½¦¡¤£¤@­Pªº¿ù»~Àˬd¥X²{
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

®@,ÁÂÁ®v¥S!
§Y¬O³o¼Ë¶Ü?
=INDEX($B$6B$11,MATCH(1,($F6=$A$6A$11)*($G6<=$C$6C$11),0))

¤T¨¤§Î®ø¥¢¤F

TOP

®@,ÁÂÁ®v¥S!
§Y¬O³o¼Ë¶Ü?
=INDEX($B$6B$11,MATCH(1,($F6=$A$6A$11)*($G6<=$C$6C$11),0))

¤T¨¤§Î®ø¥¢¤F

TOP

        ÀR«ä¦Û¦b : §ïÅܦۤv¬O¦Û±Ï¡A¼vÅT§O¤H¬O±Ï¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD