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

VLOOKUP¬d¸ß¦h­Óµ²ªG

VLOOKUP¬d¸ß¦h­Óµ²ªG

¬Ý¹Ï
°}¦C¤½¦¡
{=IFERROR(VLOOKUP(B$10&ROW(A1),IF({1,0},$B$2:$B$7&COUNTIF(INDIRECT("B2:B"&ROW($2:$7)),B$10),$C$2:$C$7),2,),"")}
ss

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD