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

The DGET function in Excel is a Database function that extracts asingle record from a database. Learn how to use the DGET function in Excel.

If you work with a large dataset or usually query the same data in an Excel table, then you should use the VLOOKUP function to make your life easier – here's how.

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.

Adding a condition to a simple revenue sheet might spell trouble in Microsoft Excel, but don't worry--a simple conditional function can handle the request.

Learn how Excel's TRIMRANGE function and Trim References operator simplify data management and enhance dynamic calculations.

By default, references in Excel use the A1 reference style, which means that it refers to the column first, and then the row number. However, the INDIRECT function enables you to switch these around.

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