Excel's VLOOKUP function searches an array of cells for data you choose, ... assuming data started on the first row. col_index_num: ... so the index number is 3.

With INDEX, you select an array, and then tell it a number, and INDEX returns that element. Walter Hickey / BI So here, INDEX gave us the 2nd element of the B2:B9 array, which is New York.

The VLOOKUP function in Microsoft Excel is a great way to find relational data. For example, you have a busy worksheet with a lot of data points, and you want to know the name of a supplier and ...