¦U¦ì¥ý¶i¦n
½Ð°Ý¦pªG¦³±ø¥ó1.2.3ªºÄæ¦ìn§@¬d¸ß¦ýn¶Ç¦^ÄæAªºÈ
=IF(IFERROR(VLOOKUP($F$6,IF({1,0},±ø¥ó¤@,¥DÃD),2,FALSE),"")="",IFERROR(VLOOKUP($F$6,IF({1,0},±ø¥ó¤G,¥DÃD),2,FALSE),""),IFERROR(VLOOKUP($F$6,IF({1,0},±ø¥ó¤@,¥DÃD),2,FALSE),""))
¬O§_¦³¿ìªk²¤Æ...¦pªG±ø¥ó¹L¦h..¤½¦¡´N·|¶VÅܶVªø
³Â·Ð¦U¦ì¥ý¶i¤F
test1.rar (6.39 KB)
|