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]).

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

HLOOKUP is a function that searches rows in your table. In this article we are going to explain how to use the HLOOKUP function in Excel.

VLOOKUP, or Vertical Lookup, is a powerful function in Excel that allows you to search for specific data in a column and return a value from a different column in the same row. Here’s a concise ...

Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.

The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

You use Microsoft Excel 's built-in function to freeze specific rows and columns (often row or column headers), so when you’re scrolling through, these cells remain stationary on the page.