Question

If the vlookup function cannot find the lookup value, the _________ error value is displayed in the cell.

Answer 1

The choices for this are:

a. #VALUE
b. #N/A
 c. #ERROR 
d. #NULL 

I believe the correct answer is option B. If the vlookup function cannot find the lookup value, the #N/A error value is displayed in the cell. It means not available. Hope this helps. Have a nice day.