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.

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

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

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