Tutorials

Photo of magnifying glass.

What is XLookup?

What is XLookup? XLookup is the latest, most flexible and fastest performing lookup function available in Excel. It is only available with a Microsoft 365 subscription, however and will not be added to older versions of Excel. While in many ways XLookup is similar to older lookup functions like VLookup and HLookup, it has some

What is XLookup? Read More »

Photo of magnifying glass.

What is HLookup

What is HLookup? HLookup searches for a value in the top row of a table and then returns a value in the same column from a row that you specify. HLookup is useful when comparison values are located in a row across the top of a table, and the desired values are in a specified

What is HLookup Read More »