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

[µo°Ý] °ß¤@±ý¤ñ¹ïªºÄæ¦ì¦b«á­±¡A¦ý¸ê®Æ¦b«e­±

[µo°Ý] °ß¤@±ý¤ñ¹ïªºÄæ¦ì¦b«á­±¡A¦ý¸ê®Æ¦b«e­±

¦U¦ì¦n
¨Ï¥Î°ß¤@­È¼t°ÓÄæ¦ì
·Q§âSheet2ªº¸ê®Æ¥Î¤½¦¡¾É¤JSheet1

¦³¨Ï¥Î=IF(ISNA(VLOOKUP($A2,Sheet2!$A:$B,2,)),"",VLOOKUP($A2,Sheet2!$A:$B,2,))
¦ý¦n¹³°ß¤@±ý¤ñ¹ïªº¸ê®ÆSheet2¼t°ÓÄæ¦ì»Ý­n©ñ¦b«e­±(AÄæ¦ì)

¦pªG°ß¤@±ý¤ñ¹ïªº¸ê®ÆSheet2¼t°ÓÄæ¦ì©ñ¦b«á­±(DÄæ¦ì)¡A«e­±¸ê®Æ´N¨Sªk§e²{
½Ð°Ý¦p¦ó­×§ï
ÁÂÁÂ

¤½¦¡.rar (29.12 KB)

¦^´_ 1# pupai

D2 { =INDEX(Sheet1!A:A,SMALL(IF((Sheet1!$B$2:$B$4=$A2)*(Sheet1!$C$2:$C$4=$B2),ROW($B$2:$B$4),99),ROW($A$1)))&""}

TOP

¦^´_ 2# samwang


    µLªk¨Ï¥Î

TOP

¦^´_ 3# pupai

¦pªþ¥ó¡AÁÂÁÂ

¤½¦¡.zip (37.07 KB)

TOP

=LOOKUP(1,0/(MMULT(N(A2:C2=Sheet1!B$2:D$4),{1;1;1})=3),Sheet1!A$2:A$4)
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

³æ¯Á¤Þ¤ñ¹ï//
=INDEX(Sheet2!A:A,MATCH($A2,Sheet2!$D:$D,))

TOP

¦^´_ 6# ­ã´£³¡ªL


    ¥H³Æ¥÷¡C·PÁ±zªº¦^ÂÐ

TOP

¦^´_ 5# hcm19522


    ·PÁ±zªº¦^ÂÐ

TOP

¦^´_ 4# samwang


    ·PÁ±zªº¦^ÂÐ

TOP

        ÀR«ä¦Û¦b : ¬°¦Û¤v§äÂǤfªº¤H¥Ã»·¤£·|¶i¨B¡C
ªð¦^¦Cªí ¤W¤@¥DÃD