185k views
5 votes
If the vlookup function cannot find the lookup value, the _________ error value is displayed in the cell.

1 Answer

4 votes
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.
User Samsin
by
6.3k points