Math, asked by Kamaan3172, 11 months ago

In a vlookup formula, what does the argument column_index_number mean?

Answers

Answered by amitnrw
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 Instagrump35
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