In order to remove the N/A error you can use of the excel function as shown ... =IF(ISERROR(VLOOKUP(AG6,$B$6:$G$32,3,FALSE)),0,VLOOKUP(AG6 ...
確定! 回上一頁