excel 同時比對多個條件,回傳值- Yahoo!奇摩知識+

Sheet2 D1 =IF((A1="")+(A1="支出"),"",VLOOKUP(C1,OFFSET(Sheet1!$A$1, MATCH (B1,Sheet1!A:A,)-1,1,4,2) ...

tw.knowledge.yahoo.com