ªð¦^¦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 : ½_ÁJµ²±o¶V¹¡º¡¡A¶V·|©¹¤U««¡A¤@­Ó¤H¶V¦³¦¨´N¡A´N­n¶V¦³Á¾¨Rªº¯ÝÃÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD