Spill using "#" not working ? Formula is fine without the "#"

[Zomgz92]

Hi All,

I was trying to make the formula spill using the hash key, but it comes back with a value error, anyone knows a fix?

=IFNA(SUM(INDIRECT(CELL("address",INDEX('Comparison Period'!$E:$E,MATCH(A8&B8,Cowd_Uploads__3[Merged],0)))&":"&SUBSTITUTE(ADDRESS(1,MATCH($B$1,'Comparison Period'!$1:$1,0),4),"1","")&MATCH(A8&B8,'Comparison Period'!$BD:$BD,0))),0)

 

[Zomgz92]

=IFNA(SUM(INDIRECT(CELL("address",INDEX('Comparison Period'!$E:$E,MATCH(A8#&B8#,Cowd_Uploads__3[Merged],0)))&":"&SUBSTITUTE(ADDRESS(1,MATCH($B$1,'Comparison Period'!$1:$1,0),4),"1","")&MATCH(A8#&B8#,'Comparison Period'!$BD:$BD,0))),0) , this is how I placed the spill hash!