Can someone please help me with this formula? I know I am doing something wrong with the punctuation near the 0 but not sure what.
Thanks!!
if(iserror(VLOOKUP($B9,'[Ins Allocation JE.xls]FORMAT PSJE'!$A$5:$P$112,10,FALSE),0,(VLOOKUP($B9,'[Ins Allocation JE.xls]FORMAT PSJE'!$A$5:$P$112,10,FALSE)
Thanks!!
if(iserror(VLOOKUP($B9,'[Ins Allocation JE.xls]FORMAT PSJE'!$A$5:$P$112,10,FALSE),0,(VLOOKUP($B9,'[Ins Allocation JE.xls]FORMAT PSJE'!$A$5:$P$112,10,FALSE)