SOLVED

#SPILL

%3CLINGO-SUB%20id%3D%22lingo-sub-2491811%22%20slang%3D%22en-US%22%3E%23SPILL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2491811%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20i%20am%20just%20trying%20to%20make%20a%20connection%20between%202%20sheets%20and%20it%20doesn't%20work.%20connection%20is%20between%202%20marged%20cells%20to%202%20marged%20cells.%20it%20comes%20like%26nbsp%3B%26nbsp%3B%23SPILL%20.%20It%20is%20date%20-%20so%20after%20connection%20is%20going%20to%20SPILL%2C%20if%20i%20change%20format%20from%20general%20to%20Short%20date%20it%20comes%20like%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3D%40'Cover%20sheet'!K8%3AL8%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2491811%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2491826%22%20slang%3D%22en-US%22%3ERe%3A%20%23SPILL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2491826%22%20slang%3D%22en-US%22%3Eit%20comes%20like%20VALUE!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2492166%22%20slang%3D%22en-US%22%3ERe%3A%20%23SPILL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2492166%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1089712%22%20target%3D%22_blank%22%3E%40Petrik1010%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%3D'Cover%20sheet'!K8%3AL8%20returns%20range%20from%20two%20values%2C%20if%20you%20have%20not%20enough%20space%20to%20it%20that%20will%20be%20%23SPILL%20error%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%3D%40'Cover%20sheet'!K8%3AL8%20returns%20%23VALUE%20error%20since%20here%20there%20is%20no%20conversion%20to%20array%20and%20back%20to%20range%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%3D%40VALUE('Cover%20sheet'!K8%3AL8)%20shall%20return%20value%20from%20K8%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
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