Case 3-2
Susan is in charge of the inventory reports for her company. She will need to find specific inventory items as well as project increases in inventory costs. To get ready she will create a worksheet and use the Microsoft Excel 2016 Analysis tools.
-Susan uses VLOOKUP to retrieve the return value from a vertical lookup table. When she enters the VLOOKUP function, specifying the lookup value and other criteria, the lookup value cannot be found. It displays ______ error value in the cell.
A) #####
B) #Value
C) #N/A
D) Value not found

Question

Case 3-2
Susan is in charge of the inventory reports for her company.  She will need to find specific inventory items as well as project increases in inventory costs.  To get ready she will create a worksheet and use the Microsoft Excel 2016 Analysis tools.
-Susan uses VLOOKUP to retrieve the return value from a vertical lookup table.  When she enters the VLOOKUP function, specifying the lookup value and other criteria, the lookup value cannot be found.  It displays ______ error value in the cell.
A) #####
B) #Value
C) #N/A
D) Value not found

Quizplus · Accepted Answer

When the VLOOKUP function is unable to find the lookup value in the table array, it displays the #N/A error value in the cell. This indicates that the value searched for is not available in the specified table. The other options are incorrect because ###### usually appears when the cell is not wide enough to fit the result, #Value usually appears when there is an error in the formula, and "Value not found" is not a recognized error value in Excel.

Case 3-2 Susan Is in Charge of the Inventory Reports for Her