請問EXCEL VLOOKUP函數.抓不到者用空白顯示. - Yahoo!奇摩知識+

請問EXCEL VLOOKUP函數.抓不到者用空白顯示. 我有一個工作 IF(A3"",IF(ISNA(VLOOKUP(B3,INDIRECT("["&$A$1&".xls]"&M$2&"!$A:$F"),6,0)),"",VLOOKUP(B3,INDIRECT(" ...

tw.knowledge.yahoo.com