How to use the Excel SHEET function

Summary

The Excel SHEET function returns the index number of a sheet in Excel. It will report the sheet number for a cell reference, named range, or Excel Table.

Purpose

Get sheet index number

Return value

The index number of a given sheet

Syntax

=SHEET ([value])

Arguments

value - [optional] The value to check.

Usage notes

Use the SHEET function to get the index number for a given sheet. The index number represents the numeric sequence of sheets in an Excel workbook, starting with 1 on the left and ending with N on the left, where N is the total number of sheets in the workbook. The SHEET function includes hidden sheets in the numbering sequence.

For example, in a workbook with Sheet1, Sheet2, and Sheet3 running left to right, the following formula will return 2:

=SHEET(Sheet2!A1)

If Sheet2 is dragged all the way to the left, the formula above will return 1.

Notes

If the value argument is omitted, SHEET will return the index of the sheet it's entered on.
Typically, value is supplied as a cell reference, but you can also supply a named range or the name of an Excel Table
The SHEET function includes hidden sheets in the numbering sequence.
SHEET reports the index of a sheet, the SHEETS function reports the number of sheets in a reference

Related functions

Excel ISBLANK Function

The Excel ISBLANK function returns TRUE when a cell contains is empty, and FALSE when a cell is not empty. For example, if A1 contains "apple", ISBLANK(A1) returns FALSE.

Excel ISERR Function

The Excel ISERR function returns TRUE for any error type except the #N/A error. You can use the ISERR function together with the IF function to test for an error and display a custom message, or perform a different calculation if found.

Excel ISERROR Function

The Excel ISERROR function returns TRUE for any error type excel generates, including #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL! You can use ISERROR together with the IF function to test for errors and display a custom message, or...

Excel ISEVEN Function

The Excel ISEVEN function returns TRUE when a numeric value is even, and FALSE for odd numbers. ISEVEN will return the #VALUE error when a value is not numeric.

Excel ISFORMULA Function

The Excel ISFORMULA function returns TRUE when a cell contains a formula, and FALSE if not. When a cell contains a formula ISFORMULA will return TRUE regardless of the formula's output or error conditions.

Excel ISLOGICAL Function

The Excel ISLOGICAL function returns TRUE when a cell contains the logical values TRUE or FALSE, and returns FALSE for cells that contain any other value, including empty cells.

Excel ISNA Function

The Excel ISNA function returns TRUE when a cell contains the #N/A error and FALSE for any other value, or any other error type. You can use the ISNA function with the IF function test for an error and display a friendly message when it appears...

Excel ISNONTEXT Function

The Excel ISNONTEXT function returns TRUE for any non-text value, for example, a number, a date, a time, etc. The ISNONTEXT function also returns TRUE for blank cells, and for cells with formulas that return non-text results.

Excel ISODD Function

The Excel ISODD function returns TRUE when a numeric value is odd, and FALSE for even numbers. ISODD will return the #VALUE error when a value is not numeric.

Excel ISREF Function

The Excel ISREF returns TRUE when a cell contains a reference and FALSE if not. You can use the ISREF function to check if a cell contains a valid reference.

Excel ISTEXT Function

The Excel ISTEXT function returns TRUE when a cell contains a text, and FALSE if not. You can use the ISTEXT function to check if a cell contains a text value, or a numeric value entered as text.

Excel SHEETS Function

The Excel SHEETS function returns the total number of sheets in a given reference. When no arguments are supplied SHEETS returns the total number of sheets in the workbook.

Good links

Microsoft SHEET function documentation

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.