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

Excel ROW Function

By May 6, 2014

Follow me on:

One of Excel's lesser known lookup and reference functions is the ROW function.

This function is often combined with other functions, such as INDEX, to create versatile lookup formulas.

The ROW function can be used in two ways.

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

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

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

Excel Lookup Formula 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.