1. Computing
Ted French

Excel COLUMN Function

By September 21, 2013

Follow me on:

Another of Excel's lookup and reference functions is the COLUMN function.

This function can be used in two ways.

One, it can be used to return the number of the column for the cell where the function is located in the worksheet.

Two, it can be used to return the number for a column of a given cell reference.

The COLUMN function is often combined with other functions, such as the VLOOKUP, to create versatile lookup formulas.

To find out all the details on how this function works, read this short tutorial on the Excel COLUMN Function.



Related Tutorials
Comments
No comments yet. Leave a Comment
Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>

©2014 About.com. All rights reserved.