Nest XMATCH and INDEX to display quantity.

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

Name the range Inventory.

Select cell K$5$ and type WE$006.$

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

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

Press F$3($FN$+$F$3)$ and select Inventory for the Array argument.

Click the Row$\_$num box and click the Name box drop$-$down arrow. Choose XMATCH in the list or choose More Functions to find and select XMATCH.

Click cell K$5$ for the Lookup$\_$value argument.

Click the Lookup$\_$array box and select cells A$3$:A$50.$ This XMATCH function looks in column A for the row that matches the data in cell K$5.$

Click INDEX in the Formula bar. $($Click OK if the argument list opens.$)$

Click the Column$\_$num argument in the INDEX Function Arguments dialog box.

Click the Name box drop$-$down arrow and choose XMATCH.

Type quantity in the Lookup$\_$value box.

Click the Lookup$\_$array box and select cells A$3$:H$3.$ This XMATCH function finds the cell in the $$Quantity$$ column for the row identified by the first XMATCH function.

Click INDEX in the Formula bar to see the completed formula $($Figure $6-97).$

XMATCH nested twice

Figure $6-97$ XMATCH nested twice

Click OK$.$ The result is $2.$

Click cell K$5,$ type WE$040,$ and press Enter. The quantity is updated.