Menu
EXCEL SHEET FUNCTION
Excel SHEET Function Introduction
The Sheet function in Excel retrieves the Sheet number for a given reference.
Description of Excel SHEET Function
Syntax :
=SHEET( [value] )
Parameters :
- The [value] argument given is a reference to an Excel sheet or a portion of an Excel sheet. This is an optional parameter that, if left blank, defaults to the sheet containing the function.
Step By Step Guide of SHEET Function
Example :
The spreadsheets below demonstrate four different uses of the Excel Sheet feature.
The following examples may be found in the workbook:
Sheet number 1 is the current worksheet (which contains the functions); Sheet number 2 is a worksheet named “Sheet2”; and Sheet number 3 is a sheet named “Chart1.”
Key Points
- #N/A! – This error occurs when the given [value] parameter is a sheet name that is not a valid sheet name. #REF! – This error occurs if the given [value] parameter is an invalid reference.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
