Forum Discussion
Storyboard Template
I love this! Any tips on what to add to the formula to pull the images from the example blocks? It’s only bringing a 0 (value) over for me. Will research more but also curious! Thank you so much!
- AishaSterling2 years agoCommunity Member
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!