I am using an Indirect & Match function to build a summary type spreadsheet. The problem lies that on the other spreadsheets when there is no match it returns a N/A result. What I would like the N/A to be is a 0. What is the simplest way to accomplish that? Here is a copy of the formula. =INDIRECT("'BusinessReport-2012'!P" &MATCH(A7,'BusinessReport-2012'!A:A,0))
Bookmarks