I think you may be correct in your assumption. Using the formula evaluator (ALT+T+U+F), your second constraint that references cell A1 on the Summary Sheet returns all "FALSE" for the match criteria, which would be a contributor as to why you are receiving a #N/A error.