Create a structured reference | Zoho Sheet Help Guide

How to create & use a structured reference to refer to a table

A structured reference is used to refer to an existing table that can be used in formulas to refer to that particular array. 

Syntax: =TableName[[ItemSpecifier];[ColumnSpecifier]]

where,

TableName: Denotes the name of the table.

ItemSpecifier: Lets you specify whether you wish to include the entire table or a particular cell range.
  1. #All - Denotes the entire table.
  2. #Data - Denotes only the rows containing data.      
  3. #Headers - Denotes only the header row.
  4. #Totals - Denotes only the footer row.
  5. #@ - Denotes only the current row.
ColumnSpecifier: Denotes the name of the column in the table.