Because it works vertically and horizontally, looks up things to the left, right, above, or below, and can return a whole column or row, it completely replaces its predecessors, VLOOKUP and HLOOKUP.

The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.

Excel ROW function will return the row number of a reference. ROWS will return the number of rows in a column. Learn how to use the Row and Rows function in Excel.

Freezing a row in Microsoft Excel or Google Sheets can organize your spreadsheet and make sorting through data a breeze. Here's how to do it.