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

[µo°Ý] vlookupªº·j´M½d³ò¯à¦³¤G­Ó¥H¤W¶Ü¡H

[µo°Ý] vlookupªº·j´M½d³ò¯à¦³¤G­Ó¥H¤W¶Ü¡H

½Ð°Ý¦U¦ì¥ý¶i,¦pªG§Ú¦b¤@­ÓexcelÀɸÌ,¦³sheet1,sheet2,sheet3¤T­Ó¤u§@ªí,¨º§Ú·Q¦bsheet3ªºE3Àx¦s®æ¸Ì¨Ï¥Îvlookup¨Ó§ä´Msheet1©Msheet2¸Ìªº¸ê®Æ,½Ð°Ý³o¯à¿ì¨ì¶Ü¡H

¦^´_ 1# smmriyonk

   E3=IF(ISERROR(VLOOKUP(D3,Sheet1!$A:$B,2,0)),VLOOKUP(D3,Sheet2!$A:$B,2,0),VLOOKUP(D3,Sheet1!$A:$B,2,0))

TOP

¦^´_ 2# register313


    ÁÂÁÂ¥ý¶iªº¸Ñµª,¤w¸g¸Ñ¨M°ÝÃD¤F¡C
¾Ç¥Í¤£§÷,¯à§_½Ð±Ð¥ý¶i¤@¨Ç°ÝÃD¡H
¥ý¶i´£¨Ñªº³o¬q¤½¦¡ªº·N«ä¬O¤°»ò¡H
¨º¦pªG¦³¤T­Ó¥H¤Wªº¤u§@ªí,¨º¤½¦¡­n¦p¦óªí¥Ü©O¡H

ÁٽХý¶i«ü±Ð!

TOP

¦^´_ 3# smmriyonk

   ¬d3­Ó¤u§@ªí( ¬d4­Ó¤u§@ªí¥H¦¹Ãþ±À ³Ì¦h7­ÓIF)
  =IF(NOT(ISNA(VLOOKUP(D3,Sheet1!$A:$B,2,0))),VLOOKUP(D3,Sheet1!$A:$B,2,0),
     IF(NOT(ISNA(VLOOKUP(D3,Sheet2!$A:$B,2,0))),VLOOKUP(D3,Sheet2!$A:$B,2,0),VLOOKUP(D3,Sheet3!$A:$B,2,0)))

   ¤£ª¾¬O§_¦³§ó¦nªº¼gªk

TOP

¦^´_ 4# register313


    ÁÂÁÂ¥ý¶iªº­@¤ß¦^ÂÐ,¦³µª®×´N«Ü·PÁ¤F¡CÁÂÁ±z!

TOP

        ÀR«ä¦Û¦b : ­n¤ñ½Ö§ó¨ü½Ö¡D¤£­n¤ñ½Ö§ó©È½Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD