What I'm building a consolidated income statement for a group of offices. My master sheet has every expense we use. The different branches don't always have the same expenses and only the expenses used show on the financials. To get around this, I'm trying to use IF(ISNA(Vlookup)) over several worksheets to pull into one master sheet and add them together as one number.

My formula works, unless the first branch worksheet doesn't contain the expense line item of the master sheet. Then I get the ISNA value of '0' returned.

For example. If on my master sheet I have an expense for Bonus, but the first branch worksheet doesn't pay bonus and the lien item isn't present on the worksheet, I get a zero, even though there are $50,000 in 'bonus pay' between the remaining branches.

Here's my formula:

=IF(ISNA(VLOOKUP(B6,'11'!A:M,13,FALSE)),0,(VLOOKUP(B6,'11'!A:M,13,FALSE))+IF(ISNA(VLOOKUP(B6,'12'!A:M,13,FALSE)),0,(VLOOKUP(B6,'12'!A:M,13,FALSE))+IF(ISNA(VLOOKUP(B6,'13'!A:M,13,FALSE)),0,(VLOOKUP(B6,'13'!A:M,13,FALSE))+IF(ISNA(VLOOKUP(B6,'14'!A:M,13,FALSE)),0,(VLOOKUP(B6,'14'!A:M,13,FALSE))+IF(ISNA(VLOOKUP(B6,'15'!A:M,13,FALSE)),0,(VLOOKUP(B6,'15'!A:M,13,FALSE))+IF(ISNA(VLOOKUP(B6,'16-1'!A:M,13,FALSE)),0,(VLOOKUP(B6,'16-1'!A:M,13,FALSE))))))))
So if the first worksheet is missing the line item, it doesn't work.