1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.
Ted French

Excel COLUMN Function

By May 8, 2014

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