How To Reference A Cell In Another Sheet Google Sheets - Web the basic way. For example, let’s say you have a sheet. Open or create a sheet. Pull from a different file: Reference a range of cells (with formula) 2. Reference cell in another sheet with criteria. Type = followed by the sheet name, an. On your computer, go to docs.google.com/spreadsheets/. Web click on an empty cell and type =importrange ( , ) , where is the link you copied and denotes the cells you want to import that you wrote down. Web pull data from another sheet:
Web get data from other sheets in your spreadsheet. Reference a single cell from another worksheet. Web click on an empty cell and type =importrange ( , ) , where is the link you copied and denotes the cells you want to import that you wrote down. Web the basic way. Type =importrange (url,sheet1!c2) replace url with the. Web pull data from another sheet: Pull from a different file: Reference a range of cells (with formula) 2. For example, let’s say you have a sheet. On your computer, go to docs.google.com/spreadsheets/. Type = followed by the sheet name, an. Reference cell in another sheet with criteria. Type = and select the cell in the source sheet to bring that data into the original sheet. Open or create a sheet. Web to reference a cell in another sheet using the sheet name, start by typing the sheet name followed by an exclamation mark (!), and then the cell reference.