Why don't you do something to get rid of that #N/A error? You could use IFERROR in the cell to trap the error.

Hope this helps.

Pete