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?
A.
=VLOOKUP(2,Item_table,B2,TRUE)
B.
=VLOOKUP(B2,Item_table,2,TRUE)
C.
=VLOOKUP(B2,Item_table,2,FALSE)
D.
=VLOOKUP(2,Item_table,B2,FALSE)
Explanation:
In order to accomplish the task, you will use the following formula:
=VLOOKUP(B2,Item_table,2,FALSE)