INDEX with XMATCH returns an item from a range or array according to the first or last match it finds. Like XLOOKUP, it works ...

Excel has a versatile If, Then function built right into it. We’ll show you how to use the IF function in Excel with a number of helpful examples.

Cells in Excel are referred to using relative or absolute references. A formula with relative references changes when the cell's position does. If, for example, a cell has a formula "=A1" and you ...

The IF function in Excel is a powerful tool that allows you to perform logical tests and return different values based on the results of those tests. It's commonly used to make decisions and perform ...

I've touched on a few of my favorite Excel functions that show me just how much the software can do. I'm sure you'll also have your own that make you feel like a magician whenever you use them.

But if you only do that once a year, you’ll probably have to research how to use the VLOOKUP function in Excel. For the third most used function in Excel (after SUM and AVERAGE), VLOOKUP is complex.