In D$2,$ using the ranges you named in the previous question, insert an xlookup formula that will display the Discount $\%$ based on the Amount Spent. Use a Match$\_$mode of $-1,$ which means, if an exact match is not found, return the next smaller item. Use the fill handle to fill down to D$9.$