If the VLOOKUP function cannot find the lookup value,the _________ error value is displayed in the cell.
A)#VALUE
B)#N/A
C)#ERROR
D)#NULL

Name: If the VLOOKUP function cannot find the lookup value,the _________ error value is displayed in the cell. A)#VALUE B)#N/A C)#ERROR D)#NULL
Brand: Quizplus
Rating: 4.7 (32 reviews)

Question

Quizplus · Accepted Answer

When the VLOOKUP function cannot find the lookup value, it returns the #N/A error value which stands for "Not Available". This is the most appropriate error value to indicate that the lookup value was not found.

If the VLOOKUP Function Cannot Find the Lookup Value,the _________