Excel Function : SHEET
Category
Information
Description
Returns the sheet number of the referenced sheet
Microsoft Excel Reference Page
https://support.office.com/en-us/article/SHEET-function-44718b6f-8b87-47a1-a9d6-b701c06cff24
Syntax and Description of the SHEET Excel Function
The syntax for the SHEET function in Microsoft Excel is: =SHEET(value, reference) value - the value that you want to find the sheet number for reference - the reference to the sheet that contains the value
About SHEET Excel Function
The SHEET function returns the sheet number of the reference sheet. For example, if the reference sheet is the third sheet in the workbook, the SHEET function will return 3.