For the col_index_num value,be sure to enter the number that corresponds to the column's position rather than its column letter;otherwise,the VLOOKUP formula may return ____.
A) #NAME?
B) #VALUE!
C) either a.or b.
D) neither a.nor b.

Question

Quizplus · Accepted Answer

The VLOOKUP formula returns the #NAME? error when it cannot find the specified column name. It returns the #VALUE! error when the col_index_num argument is not a number.

For the Col_index_num Value,be Sure to Enter the Number That