Remove #N/A Returns

[Steve 1962]

Hi All

I have the formula below which is working fine. The only thing is that if there is an empty cell on the source worksheet (Rockhampton), I do not want to return a value of #N/A (which is what I am getting now). A blank return would be better or whatever cell output that would allow me to undertake an average function on the returns.

=INDEX(Rockhampton!$I$3:$I$20,MATCH(1,(Rockhampton!$A$3:$A$20=B$1)*(Rockhampton!$B$3:$B$20=$A7),0))

What modification do I need to make to this formula ?

Thanks

 

[sandy666]

use IFNA(your_formula, "")

 

[Steve 1962]

use IFNA(your_formula, "")

Thanks very much sandy666. I wasn't sure how to use that one. All fixed and working well.

 

[sandy666]

You are welcome

Excel functions (alphabetical) - Microsoft Support

A complete list of all Excel functions in alphabetical order.

support.microsoft.com