In a vlookup formula, what does the argument column_index_number mean?
Answers
Answered by
3
Answer:
argument column_index_number mean
the number/position of column in table array from which the Value has to be picked
Step-by-step explanation:
in vlookup formula
the argument column_index_number mean
the number/position of column in table array from which the Value has to be picked
For example
=VLOOKUP(D3,E5:G8,2,0)
D3 is here the cell having value which has to be looked up
E5:G8 is table array
Where in First column , Value in D3 Cell be searched
Then 2 here is the column_index_number
=> Value in2nd column in the same row in which D3 cell value has been found will be poulated where vlookup formula is .
Answered by
10
Answer:
B) This is the number of the column within the selected table_array where the lookup result is located.
Explanation:
Researched it
Similar questions