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

¦³ÃöIF¤ÎHLOOKUP¨ç¼Æªº¨Ï¥ÎºÃ°Ý??

¦³ÃöIF¤ÎHLOOKUP¨ç¼Æªº¨Ï¥ÎºÃ°Ý??

¦³³]¤@­Ó¨ç¼Æ¬°=IF(A16="99",HLOOKUP(B16,$I$9:$T$11,3,TRUE),IF(A16="98",HLOOKUP(B16,$I$5:$T$7,3,TRUE),IF(A16="97",HLOOKUP(B16,$I$1:$T$3,3,TRUE),HLOOKUP(B16,$I$13:$T$15,3,TRUE))))
¦ý¤£ª¾¬°¦ó¶]¥Xªºµ²ªG¬O¿ù»~..?ÁٽЦU¦ì¤j¤j«üÂI..ÁÂÁÂ...^^(¸Ô¦pªþ¥ó Book1.rar (2.61 KB) )

¦^´_ 1# jumky
=HLOOKUP(B16,OFFSET($I$1,LOOKUP(1,1/ISNUMBER(FIND($A16,$A$1:$A$15)),ROW($1:$15))-1,,3,12),3,0)
¤ñ¹ï°Ñ¼ÆÀ³§ï¨Ï¥ÎFalse
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh


    ½Ð°ÝHsieh¤j¤j...¬°¤°»ò¥ÎIF¤ÎHLOOKUP½Æ¦X¨ç¼Æ..·|²£¥Í¿ù»~..³o¨âºØµLªk¤@°_¨Ï¥Î¶Ü?

TOP

Áª©¥D»¡¹L¤F,TRUE ­n§ï¦¨FALSE,³o¬Oºë½T¬d§ä,­n¥ÎFALSE.
A16®æ¦¡¬O¤@¯ë®æ¦¡,©Ò¥H¬°¼Æ­È¼Ò¦¡,¤½¦¡¤¤A16="97"·|±o¨ìFALSE,¦]¬°97<>'97"
©Ò¥H³£·|°õ¦æ  HLOOKUP(B16,$I$13:$T$15,3,TRUE)

TOP

¦^´_ 3# jumky

=IF(A16=99,HLOOKUP(B16,$I$9:$T$11,3,FALSE),IF(A16=98,HLOOKUP(B16,$I$5:$T$7,3,FALSE),IF(A16=97,HLOOKUP(B16,$I$1:$T$3,3,FALSE),HLOOKUP(B16,$I$13:$T$15,3,FALSE))))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 5# Hsieh


    ¶â..ÁÂÁÂANGELA¤ÎHsieh¤j¤j...­ì¨Ó¼Æ¦r¤£¯à¥[" "..¤¤¤å¤~¦æ...ÁÂÁ¨â¦ì¤j¤j...:D

TOP

        ÀR«ä¦Û¦b : ¤â¤ß¦V¤U¬O§U¤H¡A¤â¤ß¦V¤W¬O¨D¤H¡F§U¤H§Ö¼Ö¡A¨D¤Hµh­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD