In cell H$11,$ enter a formula using the XLOOKUP function. Use a structured reference to the value in the Eval Score column as the lookup value. Use an absolute cell reference to the Bonus Tiers Score column $($the range K$6$:K$9)$ as the lookup$\_$array, and an absolute reference to the Tier column $($the range L$6$:L$9)$ as the return$\_$array. Leave the if$\_$not$\_$found argument blank, and use $-1$ as the match mode to return the next smallest value. If Excel does not copy the formula automatically, fill the range H$12$:H$29$ with the formula in cell H$11.($Hint: To avoid an #SPILL error, enable implicit intersection by placing the This Row specifier $($@ character$)$ in front of field names.$)$