Nest XMATCH and INDEX to display quantity.

a$.$ Click the Inventory sheet tab and select cells A$3$:H$50.$

b$.$ Name the range Inventory.

c$.$ Select cell $K5$ and type WE$0$o$6.$

d$.$ Select cell K$6,$ click the Lookup & Reference button $[$Formulas tab, Function Library group$]$ and choose INDEX.

e$.$ Select the first argument list array, row$\_$num, column$\_$num and click OK$.$

f$.$ Select the Inventory range for the Array argument. Type a comma $(,)$ in the formula bar after the Array argument.

g$.$ Click the Row$\_$num box, click the Lookup & Reference button, and select XMATCH in the list.

h$.$ Click inside the XMATCH formula in the formula bar, and click cell $K5$ for the Lookup$\_$value arqument.