Excel MATCH is a Lookup and Reference function to search for specific items in a range of cell & return the relative position of that item in the range.

Learn how to use Excel’s INDEX and MATCH formulas to perform advanced lookups and data retrieval efficiently.

In my next article, we’ll use advanced features to use multiple criteria with XLOOKUP (). We’ll also learn how to return multiple columns with one XLOOKUP () function.

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.

Microsoft Excel’s XLOOKUP() is powerful, but combined with wildcards, it’s also flexible.

How to Use .NET Class Library in Excel VBA. Your business's software developers can work with Microsoft's .NET framework to create powerful Excel macros for your spreadsheets.

This month’s column shows how to use the remarkably versatile AGGREGATE 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 Excel TEXTSPLIT function can split text strings by using row or column delimiters. Learn how to use the new TEXTSPLIT () function in Excel.