Question

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.

Answer 1

If she had entered the vlookup function that specifies that the lookup value and other criteria in which the lookup value can't be found, the likely display in the error value of the cell is written as "#N/A" in which this will be displayed when there is an error in the value that is found in the cell.