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

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

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

¿z¿ï.jpg
2018-5-10 23:05



¦p¹Ï

¦^´_ 1# keovin790916

±q¡§¸ê®Æ¡¨¨ºÃ䦳¹L¡§¿z¿ï¡¨¥i¥H³]©w
Excel VBAºô­¶¸ê®Æ¦¬¶°±Ð¾Ç:
http://forum.twbts.com/thread-20848-1-1.html

TOP

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

TOP

        ÀR«ä¦Û¦b : ¤Ñ¤W³Ì¬ü¬O¬P¬P¡A¤H¥Í³Ì¬ü¬O·Å±¡¡C
ªð¦^¦Cªí ¤W¤@¥DÃD