SHEET

You are here:

 

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)