OFFSET Function in Excel: Syntax, Examples and Free Practice
OFFSET is an Excel Lookup & Reference function. Returns a range that's a certain number of rows/columns away from a starting cell.
OFFSET syntax
Arguments
reference: The cell or range being referencedrows: How many rows to return or generatecols: How many columns the result should includeheight: How many rows tall the range should be (optional)width: How many columns wide the range should be (optional)
When to use OFFSET
OFFSET is used to pull matching data from one part of a workbook into another.
Practice OFFSET online, free
Open the live Excel-style spreadsheet and try OFFSET yourself. No Excel install or sign-up needed to start.
Practice OFFSET now →More Lookup & Reference functions
Frequently asked questions
What does the OFFSET function do in Excel?
Returns a range that's a certain number of rows/columns away from a starting cell.
What is the syntax of OFFSET in Excel?
The syntax is =OFFSET(reference, rows, cols, [height], [width]). reference: The cell or range being referenced; rows: How many rows to return or generate; cols: How many columns the result should include; height: How many rows tall the range should be (optional); width: How many columns wide the range should be (optional).
Where can I practice OFFSET online for free?
Open the free live spreadsheet on Cellgrids and try OFFSET yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Lookup and Reference functions · Excel case studies · Excel tutorials · Excel shortcuts