You can use the COLUMN function to quickly determine the col_index_num of the VLOOKUP formula without having to count columns! Maybe you are working with a table that has 30, 50, or 100 columns and you don't want to have to count the number of columns to determine the col_index_num argument.
(Notice that I've hidden columns D through M just to collapse the table a bit, but there are 19 column in the table) I need to populate the location information from a table called Data1 that is located on a separate worksheet: I have a data range that has various information: When you get a preview, look for Download in the upper right hand corner. You can download the file here and follow along. You can find his tutorial on this topic here I learned this trick from Alan Murray from.
This works well especially if you have a very large table with lots and lots of columns. In this tutorial we are going to look at a simple and easy way to determine the column number argument for a VLOOKUP formula without having to count your columns.
