Forum Discussion
#SPILL! ERROR
I am setting up a grade book and trying to get the sheet to convert numbers within a certain range (the letter grade column below) to a Letter grade, but I am getting the #SPILL! error. Any idea how ...
For such sample
for structured table
=XLOOKUP([@Score], Grades[Number grade], Grades[Correlating Letter grade],,-1)for the range
=XLOOKUP(I4:I9,Grades[Number grade],Grades[Correlating Letter grade],,-1)