Jul 07 2022 07:16 AM
#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
Jul 07 2022 07:34 AM
@Zanele_Mbatha
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.
