The Column Index Number Argument
The column index number indicates which column of the table array contains the data you are after.
- if you enter a 2 into the column index number, VLOOKUP returns a value from the second column of the table_array;
- if the column index number is 4, it returns a value from the fourth column of the table_array.
- Click on the Col_index_num line in the dialog box
- Type a 2 in this line to indicate that we want VLOOKUP to return information from the second column of the table array.