Change #N/A to 0

[berty2000]

Hi guys

I'm doing a index/match search on several cells with formula, but those that are empty it returns a #N/A what can I add to the formula to return a 0 instead.

=INDEX('Line Matrix'!A4:A72,MATCH(D3,'Line Matrix'!B4:B72,0))

I don't want to do a conditional formatting to hide it, not sure if it is using =IFERROR ?

 

[FDibbins]

Try this...
=iferror(INDEX('Line Matrix'!A4:A72,MATCH(D3,'Line Matrix'!B4:B72,0)),0)

 

[Trebor76]

not sure if it is using =IFERROR ?

Yes, using the IFERROR function will do the job:

=IFERROR(INDEX('Line Matrix'!A4:A72,MATCH(D3,'Line Matrix'!B4:B72,0)),0)

HTH

Robert

 

[berty2000]

Thanks both of you, I was just missing the 0 and brackets at the end, thats why i was struggling.

 

[FDibbins]

Happy to help