google sheets variable cell reference code example

Example 1: get cell value from string google sheets

=CONCAT("value is ", C5)

Example 2: get data of active cell google script

let actSheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  let actData = actSheet.getActiveRange().getValue();