Give me an example ofa.$$In cell B$12,$ start to enter a formula using the XLOOKUP function.

b$.$Use the Total Q$1$ sales $($cell B$8)$ as the value to look up$.$

c$.$Use the Revenue Amts information $($range $B$$14$:$F$$14)$ as the lookup data, and Rating information $($range $B$$15$:$F$$15)$ as the return data, using absolute references to specify the range.

d$.$Specify an exact match or next smaller item $(-1)$ as the match mode.

e$.$Fill the range C$12$:E$12$ with the formula in cell B$12$ to enter ratings for Quarters $24.$