Add IF Error statement to remove #N/A

[Livin404]

Greetings,

Fluff from this group help me out greatly by providing this formula

=INDEX($G$5:$G$40,MATCH($A52,$A$5:$A$40,0)+COLUMNS($B52:B52))

. I would like to add an "If error", so I can get a 0 rather than an #NA. I think a zero suppose to go somewhere at the end of the formula. I don't want to ruin the formula already provided for me.

Thank you, so much!

 

[Fluff]

Try

=ifna(INDEX($G$5:$G$40,MATCH($A52,$A$5:$A$40,0)+COLUMNS($B52:B52)),0)

 

[Livin404]

You're right again, Thank You,

 

[Fluff]

My pleasure.