Quick Navigation
SHEET Function
Summary
The SHEET function returns the sheet number (position) of a specified sheet name, reference, or table within the workbook. It provides a dynamic way to identify sheet positions for formulas that need to reference sheets by their numeric order rather than hardcoded names.
Syntax
SHEET(value)Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| value | Reference/Text |
No | Optional. Sheet name in quotes, cell reference, or table name. Returns current sheet if omitted |
Using the SHEET Function
SHEET is valuable for creating dynamic formulas that adapt to workbook structure changes. Use it to build sheet-position-based references, create dynamic sheet selectors, or generate summary reports that reference sheets by position rather than name.
Common SHEET Examples
Get Current Sheet Number
=SHEET()Returns the position number of the sheet containing this formula (e.g., 2 if it's the second sheet).
Find Specific Sheet Position
=SHEET("SalesData")Returns the position (e.g., 3) of the sheet named 'SalesData'.
Reference from Another Sheet
=SHEET(Sheet2!A1)Returns Sheet2's position number, regardless of where the formula is located.
Table-Based Sheet Lookup
=SHEET(Table1)Returns the sheet position containing the named table 'Table1'.
Frequently Asked Questions
Common Errors and Solutions
#REF!
Cause: Invalid cell reference passed to value parameter
Solution: Use valid cell reference or sheet name
#NAME?
Cause: Worksheet-scoped name in wrong sheet context
Solution: Use workbook-scoped names or reference from correct sheet
#N/A
Cause: Sheet name doesn't exist in workbook
Solution: Verify exact sheet name spelling (case-sensitive in some contexts)
Notes
- Sheet order follows left-to-right tab position
- Includes all sheet types: worksheets, charts, macros, dialogs
- Updates automatically when sheets are moved/reordered
- Not available in Excel Object Model (VBA equivalent exists)
- Perfect companion to INDIRECT for dynamic sheet referencing
Compatibility
Available in: Excel 2013, Excel 2016, Excel 2019, Excel 2021, Excel for Microsoft 365, Excel for the web
Not available in: Excel 2010, Excel 2007, Excel 2003, Mac Excel versions before 2016
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2013+