To provide incentives for employees to sell more goods, Aleeta has set sales goals for each employee for items belonging to various categories. On the EmployeeAnalysis worksheet, you will use an INDEX function to retrieve the correct sales goal based on the EmployeeID and the desired Category. Because INDEX functions need to be told what row and column number to go to, you will use MATCH functions to do the counting an determine the correct row and column numbers for the INDEX to use.

On the EmployeeAnalysis worksheet, in cell J23, enter a MATCH function that will return the row number of whichever category is selected in cell H20. Use the fill handle to copy the formula down through J27.

In cell K23, enter a MATCH function that will return the column number of the EmployeeID in cell F23.Use the fill handle to copy the formula down through K27.

In cell H23, enter an INDEX function, using the range G5:K9 as the array, and referencing the values in J23 and K23 for the row and column numbers.Use the fill handle to copy the formula down through H27.

Change the category in cell H20 to Accessories to make sure the function retrieves the correct values.To provide incentives for employees to sell more goods, Aleeta has set sales goals for each employee for items belonging to various categories. On the EmployeeAnalysis worksheet, you will use an INDEX function to retrieve the correct sales goal based on the EmployeeID and the desired Category. Because INDEX functions need to be told what row and column number to go to, you will use MATCH functions to do the counting an determine the correct row and column numbers for the INDEX to use.

On the EmployeeAnalysis worksheet, in cell J23, enter a MATCH function that will return the row number of whichever category is selected in cell H20. Use the fill handle to copy the formula down through J27.

In cell K23, enter a MATCH function that will return the column number of the EmployeeID in cell F23.Use the fill handle to copy the formula down through K27.

In cell H23, enter an INDEX function, using the range G5:K9 as the array, and referencing the values in J23 and K23 for the row and column numbers.Use the fill handle to copy the formula down through H27.

Change the category in cell H20 to Accessories to make sure the function retrieves the correct values.