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

[µo°Ý] ¦p¦óVLOOKUP¤ñ¹ï¤G­Ó¤À­¶¸ê®Æ

[µo°Ý] ¦p¦óVLOOKUP¤ñ¹ï¤G­Ó¤À­¶¸ê®Æ

¥»©«³Ì«á¥Ñ yuras ©ó 2011-11-25 21:07 ½s¿è

­n¸ò¦U¦ì°ª¤â½Ð¯q¤F¡A¤p©f§Ú¥u·|¤ñ¥Î¤ñ¹ï¤@­ÓÄæ¦ì¡A·Q¤ñ¹ï¤G­Ó¤À­¶¸ê®Æ¥Î«Ü¤[³£·d¤£©w
EX: ¦b¦P¤@®æÀÉ®× ¦³¤T­Ó¤À­¶ ²Ä¤@¤À­¶¬Oªí®æ¡A²Ä¤G¤À­¶:©ú²Ó¡B²Ä¤T­¶:©ú²Ó1¡A
¦bªí®æ¿é¤J¦WºÙ­È ·|¤ñ¹ï§ì©ú²Ó¡B©ú²Ó1 ±a¥X¼Æ­È?? ¥t¥~¦pªG¤ñ¹ï¥X¨Ó¬O #/NA ´N¤£­nÅã¥Ü  
ÁÂÁ ¦U¦ì°ª¤â ^^

¥»©«³Ì«á¥Ñ register313 ©ó 2011-11-25 21:55 ½s¿è

¦^´_ 1# yuras


    B2=IF(ISERROR(VLOOKUP(A2,Sheet2!$A:$B,2,0)),"",VLOOKUP(A2,Sheet2!$A:$B,2,0))
    C2=IF(ISERROR(VLOOKUP(VALUE(123&B2),Sheet3!$A:$B,2,0)),"",VLOOKUP(VALUE(123&B2),Sheet3!$A:$B,2,0))

Book1.zip (1.83 KB)

TOP

·PÁ !!! ¤w¸Ñ¨M:)
B2=IF(ISERROR(VLOOKUP(A2,Sheet2!A:B,2,0)),(VLOOKUP(A2,Sheet3!A:B,2,0),VLOOKUP(A2,Sheet2!A:B,2,0))
C2¦b³]¤@¦¸¤ñ¹ï

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2011-11-26 23:25 ½s¿è

¦^´_ 3# yuras

B2=IF(COUNTIF(Sheet2!A:A,$A2),VLOOKUP($A2,Sheet2!$A:$B,2,0),IF(COUNTIF(Sheet3!A:A,$A2),VLOOKUP($A2,Sheet3!$A:$B,2,0),""))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¬°¤H³B¥@­n¤p¤ß²Ó¤ß¡A¦ý¤£­n¡u¤p¤ß²´¡v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD