Forum Discussion
#SPILL! From a Referenced Merged Cell.
Hi everyone, I have a spreadsheet that I'm trying to build for my work flow to enable track my daily sales activities and simultaneously compute my percentage earnings per customer. For me to achieve...
That means you are on dynamic array version of Excel and your formula returns an array for which not enough space. 2019 returns only first element of such array. Better to rework the formula, but you may try to put in front of it @ sign. For example, if your formula
=INDEX(...)
convert it to
=@INDEX(...)
ituryu , you are welcome
SergeiBaklan I am trying to populate an empty merged cell with a merged text cell from one sheet to another. It is now displaying #Value! instead of the name I am trying to reference. For reference, the formula I am using is =@'Client Info Sheet'!B6:D6.
Did you try ='Client Info Sheet'!B6 ?
