Function name | SHEET |
Type | TotalSheets specific |
Arguments | – sheet_number – cell_range |
Syntax | =SHEET(sheet_number, cell_range) |
Description | Returns the value or range from another sheet in the spreadsheet. |
The arguments description:
– sheet_number – a sheet number (1, 2, …) or cell address (A1, C7, …), specifying number of sheet,
– cell_range – a cell address (A1, F4, …) or cell range (A1:G6).
Examples:
=SHEET(1,B17) =SHEET(2,C1:C25) =SHEET(D4,F2:G12)