Occasional Visitor

#Spill! I am getting this spill error on my formula:


=XLOOKUP(A39:A84,'Stock Valuation_June22 SUMM (2)'!A6:A737,'Stock Valuation_June22 SUMM (2)'!L6:L737,0,0,1)


Please help

1 Reply


The first argument A39:A84 of XLOOKUP consists of 46 cells, so the formula will return 46 values below each other.

There must be enough room below the cell where you enter the formula for those 46 values.