In Microsoft Excel, VLOOKUP (vertical lookup) is a search function that you can use to find any data inside a particular column of the table by looking at the first column's entries and returning ...

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’s database functions are often overlooked, yet they have the potential to transform complex data management tasks.

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.

Microsoft Excel's new FILTER() function is a great tool for reporting and dashboards. We'll show you how to use it to get more done.

If you need to use the Excel IF function and multiple conditions, consider using the IFS function instead. This allows you to test multiple conditions in order, picking the first that returns true.