In this article, I will use A1-style references to show you how the INDIRECT function works. Once you've grasped its concepts, you can experiment using R1C1-style references.

To pull data from another sheet in Excel, use cell references, use the VLOOKUP function, or use the INDEX and MATCH functions.

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.

Discover why Excel's INDIRECT function is outdated and learn smarter alternatives like Power Query, FILTER, and LAMBDA for better workflows.

You can sum cells across multiple sheets in Excel. This article presents steps for Adding single-cell values or Adding values in the range of cells.

How to use the powerful Microsoft Excel VLOOKUP feature that allows you to search for specific data in a column and return a value from a ...