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:
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.
The spreadsheets below show examples of the Excel Sheet function.
Further examples of the Excel Sheet function are provided on the Microsoft Office website.
If you get an error from the Excel Sheet function, this is likely to be one of the following:
|#N/A!||-||Occurs if the supplied [value] argument is a sheet name that not a valid sheet.|
|#REF!||-||[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.For example, if the|