Max, for charting it is actually better to have N/A, otherwise, if you put data labels into the chart, it will show zero when there is no column. With N/A the chart will be cleaner. Also, the N/A is a "natural" result of the formula if there is no value found for the criteria. Trying to error-trap it and exchange the N/A for a 0 would be a waaaay much longer formula. Like this:
=if(isna(INDEX('Channel Monthwise'!$C$3:$C$14,MATCH($A2&B$1,INDEX('Channel Monthwise'!$A$3:$A$14&'Channel Monthwise'!$B$3:$B$14,0),0))),0,INDEX('Channel Monthwise'!$C$3:$C$14,MATCH($A2&B$1,INDEX('Channel Monthwise'!$A$3:$A$14&'Channel Monthwise'!$B$3:$B$14,0),0)))
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
Bookmarks