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

[µo°Ý] §Ú­n¦h­«¿z¿ï­n¦p¦ó¨Ï¥Î? MATCH?

ÃC¦â =LOOKUP(0,0/((B1:B9="­^°ê")*(C1:C9="¶§¥ú")), A1:A9)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ª¾ÃÑ­n¥Î¤ßÅé·|¡A¤~¯àÅܦ¨¦Û¤vªº´¼¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD