# The Excel SHEET Function

Related Function:
SHEETS Function

## Function Description

The Excel Sheet function returns the Sheet number for a specified reference.

Note: the Sheet function was introduced in Excel 2013 and so is not available in earlier versions of Excel.

The syntax of the function is:

SHEET( [value] )

Where the supplied [value] argument is a reference to an Excel sheet or a part of an Excel sheet. This is an optional argument which, if omitted, defaults to the sheet that contains the function.

## Sheet Function Examples

The spreadsheets below show four examples of the Excel Sheet function.

In the workbook containing the examples:

• The current worksheet (that contains the functions) is sheet number 1;
• A worksheet named "Sheet2" is sheet number 2;
• a sheet named "Chart1" is sheet number 3.
Formulas:
A B
1 =SHEET( ) - defaults to the current worksheet
2 =SHEET( "Sheet2" ) - the name of a worksheet named "Sheet2"
3 =SHEET( Sheet2!A1 ) - a reference to a cell in Sheet2
4 =SHEET( "Chart1" ) - the name of a Chart sheet named "Chart1"
Results:
A B
1 1
2 2
3 2
4 3

For further examples of the Excel Sheet function, see the Microsoft Office website.

## Sheet Function Errors

If you get an error from the Excel Sheet function, this is likely to be one of the following:

Common Error
 #N/A! - Occurs if the supplied [value] argument is a sheet name that not a valid sheet. #REF! - Occurs if the supplied [value] argument is a non-valid reference. For example, if the [value] argument had previously referenced cell Sheet2!A1, but then Sheet2 was deleted or cell Al within Sheet2 was deleted, this would no longer be a valid reference.