Hi:
The formula below is suppose to return zero when value in B4 cannot be match to facilitate SUM calculation using B4. But, SUM formula is returning #VALUE
B4 = IFERROR(INDEX(List!$N$8:$N$80,MATCH('Report2'!B4,List!$AA$8:$AA$80,0)),0)
Can you help please?
Regards,
Sean