Index Match - N/A

[italy16]

Hello - How do I get the following equation to return 0 instead of N/A if no match? Note - I'm on excel for Mac. Thank you in advance

{=INDEX('OPEX Detail'!$Y$2:$Y$927,MATCH(1,('Updated Budget Upload 2019'!J16='OPEX Detail'!$F$2:$F$927)*('Updated Budget Upload 2019'!F16='OPEX Detail'!$C$2:$C$927),0))}

 

[Jeffrey Mahoney]

Please try this:
=iferror({INDEX('OPEX Detail'!$Y$2:$Y$927,MATCH(1,('Updated Budget Upload 2019'!J16='OPEX Detail'!$F$2:$F$927)*('Updated Budget Upload 2019'!F16='OPEX Detail'!$C$2:$C$927),0))},0)

 

[italy16]

Thank you. It worked!