Adding IF to INDEX MATCH formula - results in some cells being #NA

[slstewart249]

I am trying to add an IF condition to an Index/Match formula.

Row 3 is a list of Dates (AZ$3)
Row 8 is a list of Dates I am trying to match Row 3 to
Row 9 is a list of $ values to return when a date in Row 3 matches a date in Row 8.

When the dates match the correct value is returned. When there is NOT a match, I get #NA . I want to get a Zero return when there is not a match.

=IF(MATCH(AZ$3,$DO$8:$DZ$8,0),INDEX($DO$8:$DZ$9,2,MATCH(AZ3,$DO$8:$DZ$8,0)),0)

How should I re-write this formula?

 

[OGCV1]

Try use an IFERROR() to surround your INDEX MATCH formula instead of an IF.

 

[Aladin Akyurek]

[1] If IFNA is available on your system...

=IFNA(INDEX($DO$9:$DZ$9,MATCH(AZ3,$DO$8:$DZ$8,0)),0)

[2] If IFNA is not available on your system...

=IFERROR(INDEX($DO$9:$DZ$9,MATCH(AZ3,$DO$8:$DZ$8,0)),0)