Forum Discussion
#SPILL - How to solve without splitting cells
Hello, First, my english isn't best, so hopefully you can understand what I want. Well, I need to get the value of a cell in one worksheet shown in a cell in another worksheet, problem is that ...
I my case the error comes because I had connected cells, so it tryed to get values out of multiple cells that are not existing and put them in multiple cells that are one... however, as I sayed I solved it with a Workaround using the =VALUE(@'Blatt1'!C12:BJ12) formula (hope german WERT is english VALUE)
Another good option is to use INDEX function. =INDEX('Blatt1'!C12:BJ12,1,1)