Microsoft Exam 77-427 Topic 9 Question 25 Discussion

You work as a Sales Manager for Maini Industries. Your company manufactures and sells construction equipment. You have to create a report that will show the highest selling items of each month. The report will be in the following format:

In a workbook, you create a table named Item_table as shown below:

You fill in the required entries in the workbook.

For the third column of the sheet, you want to use formulas to fill in the values. You want the cells in the third column to get automatically filled with the names corresponding to ItemID in the second column. You want the exact values to be filled in the column. You select the C2 cell in the third column.

Which of the following formulas will you enter in order to accomplish the task?