- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Information - SHEET Function
Description
The SHEET function returns the sheet number of the reference sheet.
Syntax
SHEET (value)
Arguments
Argument | Description | Required/ Optional |
---|---|---|
Value | Value is the name of a sheet or a reference for which you want the sheet number. If value is omitted, SHEET returns the number of the sheet that contains the function. |
Optional |
Notes
SHEET includes all worksheets (visible, hidden or very hidden), in addition to all other sheet types (macro, chart, or dialog sheets).
If the value argument is a non-valid reference, SHEET returns the #REF! error value.
For example, if the value argument had previously referenced cell Sheet2!A1, and Sheet2 was deleted later or the cell Al within Sheet2 was deleted later, this would no longer be a valid reference.
If the value argument is a sheet name that is not valid, SHEET returns the #NA error value.
Applicability
Excel 2013, Excel 2016