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

[µo°Ý] INDEX+MATCH¥\¯àºÃ°Ý?

[µo°Ý] INDEX+MATCH¥\¯àºÃ°Ý?

1.E2Àx¦s®æ¨Ï¥Î =IFERROR(INDEX(A:B,MATCH(D2,B:B,FALSE),COLUMN(A:A)),"")...°}¦C¤½¦¡
2.­Y©m¦W¤Î¥N½XÄæ¦b E2 Àx¦s®æ¥ª°¼ ¸Ó¤½¦¡¨Ï¥Î¤W¯à¥¿½TÅã¥Ü©Ò­nªº©m¦W
3.¨Ò¦p ¦bD2¿é¤J¥N½X 3456 ¡AE2Àx¦s®æ·|¦Û°ÊÅã¥Ü©m¦W ¤ýªZ
4.­Y¬O±N©m¦W¤ÎÄæ¦ì²¾¦Ü E2 Äæ¥k°¼...¤W­z°}¦C¤½¦¡µLªkÅã¥Ü¥¿±`µª®×
5.½Ð°Ý¸Ó¦p¦ó­×§ï¤W­z°}¦C¤½¦¡¤~¯àÀò¨ú¥¿½Tµª®×¡C

1090603.rar (7.23 KB)

³o¤£¶·¥Î¨ì°}¦C¤½¦¡:
=IFERROR(INDEX(H:H,MATCH(D2,I:I,)),"")

TOP

¦^´_ 2# ­ã´£³¡ªL
·P®¦
°ÝÃD¤w¸Ñ¨M¡AÀò¯q¨}¦h ^^

TOP

©Ó¤W¬ÛÃö°ÝÃD
­YD2¿é¤J¥N½X 8520
§Æ±æ E2 Àx¦s®æ...¬dµL¦¹¥N½X
­YD3~D6¥¼¿é¤J¥N½X«h E3~E6 [img][img][/img][/img]Åã¥ÜªÅ¥Õ

1090604.rar (7.26 KB)

TOP

=IF(D2="","",IFERROR(VLOOKUP(D2,IF({1,0},H:H,I:I),2,),"¬dµL¦¹¥N½X"))
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 5# hcm19522
·PÁ±z«ü¾É
¨Ì«ü¾É¥N¤J¤½¦¡
¥u­n¦³¿é¤J¥N½XÀx¦s§¡Åã¥Ü¬dµL¦¹¥N½X...
¥¿½Tªºµª®×¬O¿é¤J¥¿½T¥N½X«hÅã¥Ü©m¦W
¿é¤J¿ù»~ªº¥N½X¯àÅã¥Ü¬dµL¦¹¥N½X
¥¼¿é¤J¥N½XÀx¦s®æ«hÅã¥ÜªÅ¥Õ

sshot-1.jpg (47.01 KB)

E3Àx¦s®æÅã¥Ü¿ù»~...

sshot-1.jpg

1090605.rar (7.65 KB)

TOP

=if(d2="","",IFERROR(INDEX(H:H,MATCH(D2,I:I,)),"¬dµL²Å¦X"))

TOP

¦^´_ 7# ­ã´£³¡ªL
Æg°Õ!!
©Ò¹J°ÝÃD¤wªï¤b©ó¸Ñ...
¦UºØ¨ç¼Æ¤§¹B¥Î¯à²¤Æ­Ó¤H¤u§@¤W¤§®Ä²v»P´£¤É

TOP

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