Simnet Guided project $6-3.$

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).$