If the VLOOKUP function cannot find a match in the lookup table, what does it return?
A) "Match not found" message
B) #N/A error value
C) FALSE
D) #NAME error value

Name: If the VLOOKUP function cannot find a match in the lookup table, what does it return? A) "Match not found" message B) #N/A error value C) FALSE D) #NAME error value
Brand: Quizplus
Rating: 4.7 (41 reviews)

Question

Quizplus · Accepted Answer

When the VLOOKUP function cannot find a match in the lookup table, it returns the #N/A error value.

If the VLOOKUP Function Cannot Find a Match in the Lookup