I'm trying to create a sheet that automatically rearranges the financial reports generated from quickbooks.
In column A, I have our accounting codes (i.e. "income")
In column B, I have the actual performance numbers.
In column C, I have the budgeted numbers.
If nothing has been booked in the month, column B shows 0.
I need Excel to find a code in column A ("Income") and return the value on the same row in column B (actual performance) unless that value is 0 (month hasn't happened yet), in which case I need it to return the value in the same row in column C (the budgeted amount).
I was using this: =IF(B1=0,C1,INDEX(A:A,MATCH("Income",B:B,0))) but the IF statement will break if my rows change from month to month (which they will depending on if codes are unused during that month).
I'm starting to see double and am getting Excel-brain-overload. Can anyone help out?
Bookmarks