12 Replies
Aisha Sterling

In the Section tabs, Check the cells that return a 0 value.  e.g In cell D9, the formula will probably look as follows:

=INDEX(Blocks!$C$2:$C,MATCH($B9,Blocks!$B$2:$B)).

Change the part that I highlighted above because it need to match from column C.  The top row in each block is usually correct so you can copy the formula down.

Cell D9 for example should read:

=INDEX(Blocks!$C$2:$C,MATCH($C9,Blocks!$B$2:$B))

 

Its the same issue across all the cells that have this error, so just copy the formula from the top cell of that block and drag down for each one.

 

Hope this helps!