For many, the INDEX-XMATCH combination in Excel is the go-to method for retrieving a value from a dataset. However, you can ...

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

A little from column A, a little from column B: XLOOKUP is the new, easier way to retrieve information across Excel spreadsheets.

A combo box's autocomplete feature linked to a lookup function creates a flexible search tool.

The Row function in Microsoft Excel is a Lookup and Reference function, and its purpose is to return the row number of a reference. The formula for the Row function is Row([reference]).

Excel can solve equations through several of its mathematical functions, but the single Excel tool that works on the largest variety of equations is the program's Solver Add-in.

Press F10, and small letters appear over each ribbon tab and quick access toolbar item. Alt+H takes you to the Home tab, ...

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