Excel's VLOOKUP Function

By Ted French, About.com Guide

The Column Index Number Argument

The column index number indicates which column of the table array contains the data you are after.

For example:

• 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.

Tutorial Steps

1. Click on the Col_index_num line in the dialog box


2. Type a 2 in this line to indicate that we want VLOOKUP to return information from the second column of the table array.

Previous

• Using Excel's VLOOKUP Function
• Entering the Tutorial Data
• The VLOOKUP Dialog Box
• The Lookup Value Argument
• The Table Array Argument
• The Column Index Number Argument
• The Range Lookup Argument
• Using the VLOOKUP Function
• Excel VLOOKUP Error Messages

Next