Forum Discussion
automatically update the single cell value of one sheet when I drag down column of other sheet
Dear experts: I wish when I drag down the column Q at the sheet 1, the value of the single cell B5 at sheet 2 (sheet name:c_calculated) will be automatically updated to the repsected row value fr...
For Excel
=INDIRECT("Sheet1!N" & ROW())
Google Sheets, Google Drive, and OneDrive do not support the INDIRECT function in the same way as Excel. While Google Sheets does support the INDIRECT function, the syntax may differ slightly, and it does not support direct cell references across different sheets in the same way Excel does.
For Googlesheets
=IMPORTRANGE("Spreadsheet_URL", "Sheet1!N5:N")
Hope this will help you.