Forum Discussion
something in and or about that formula wants to output a range of values and that range of rows/columns it is trying to spill those results into include 1 or more cells that already have a value or formula. So either delete or move the existing data/formula(s) out of that 'spill range' or change the formula so it is not outputing as large or any spill values. If you were not expecting a range of values output then you probably made a mistake in the formula. Here are some simple spill examples:
=A1:A10 <= this will copy the values from A1:A10 and show them in the current cell and spill into the the 9 cells below it
=XLOOKUP( A1:A10, B1:B10000, C1:C10000 ) <= this will use the values in A1:A10 and for each respective value is will look in B1:B10000 for that value and return the corresponding value in C1:C10000. This will spill the same as above with this cell plus the 9 cells below it.
=SEQUENCE( 10,10 ) <= this formula will create a sequence of number 10 rows and 10 columns so it will spill 10 down and 10 to the right and display the number 1 - 100