SHEET function
Summary
Returns the sheet number of the referenced sheet
Syntax
SHEET(value)
The SHEET function syntax uses only the one following argument.
• value Optional argument. Use this to specify the name of a sheet or a reference for which you want to obtain the sheet number. Otherwise, the function will return the number of the sheet containing the SHEET function.
• value Optional argument. Use this to specify the name of a sheet or a reference for which you want to obtain the sheet number. Otherwise, the function will return the number of the sheet containing the SHEET function.
Example
=SHEET(QSalesByRegion)
=SHEET(Table1)
=SHEET(Hi_Temps)
=SHEET("Stuff")
=SHEET(Table1)
=SHEET(Hi_Temps)
=SHEET("Stuff")