SOLVED

#SPILL

New Contributor

Hello, i am just trying to make a connection between 2 sheets and it doesn't work. connection is between 2 marged cells to 2 marged cells. it comes like  #SPILL . It is date - so after connection is going to SPILL, if i change format from general to Short date it comes like 

 

=@'Cover sheet'!K8:L8

4 Replies
it comes like VALUE!
best response confirmed by Petrik1010 (New Contributor)
Solution

@Petrik1010 

='Cover sheet'!K8:L8 returns range from two values, if you have not enough space to it that will be #SPILL error

 

=@'Cover sheet'!K8:L8 returns #VALUE error since here there is no conversion to array and back to range

 

=@VALUE('Cover sheet'!K8:L8) shall return value from K8

@Sergei Baklan 

Thank you

@Petrik1010 , you are welcome