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

[µo°Ý] ½Ð±Ð¦p¦ó¨Ï¥Î vlookup¤½¦¡¤W¤UÂù¦V¬d¸ß?

¦^´_ 1# peter460191

D3 ¿é¤J 1101©Î¥xªd
D4 ¤½¦¡ =IF(ISNA(MATCH(D3,A:A,)),"",INDEX(B:B,MATCH(D3,A:A,))) & IF(ISNA(MATCH(D3,B:B,)),"",INDEX(A:A,MATCH(D3,B:B,)))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¤£©È¨Æ¦h¡A¥u©È¦h¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD