Google sheets reference another sheet

ST

by Sanskar Tiwari

In Google Sheets, you can reference data from another sheet in your spreadsheet using the following syntax:
SHEET_NAME!CELL_REFERENCE
For example, if you wanted to reference cell A1 on a sheet called "Data" in the same spreadsheet, you would use the following syntax:
Data!A1