About 1,074,031 results (3,292 milliseconds)
How can you use a cell reference in place of Sheetname in a query ...
https://support.google.com/docs/thread/2992104/how-can-you-use-a-cell-reference-in-place-of-sheetname-in-a-query-formula?hl=en Mar 25, 2019 ... How can you use a cell reference in place of Sheetname in a query formula. I have this query formula. =query({'Sheet Name'!B10:B,'Sheet Name ...
Get the active sheet's name to be in a cell - Google Docs Editors ...
https://support.google.com/docs/thread/87383462/get-the-active-sheet-s-name-to-be-in-a-cell?hl=en Dec 7, 2020 ... hopefully this can be done with a formula. I am not familiar with how to run scripts in sheets. I have done it with excel in the past. Details.
Using Indirect to put a sheet name and cell reference together not ...
https://support.google.com/docs/thread/149906414/using-indirect-to-put-a-sheet-name-and-cell-reference-together-not-working-when-sheet-name-updated?hl=en Feb 8, 2022 ... I then have a formula which pulls a cell from each sheet based on their name using the number column. I am using the indirect formula =INDIRECT( ...
Using a cell value as worksheet name in an Index Match formula ...
https://support.google.com/docs/thread/182192198/using-a-cell-value-as-worksheet-name-in-an-index-match-formula?hl=en Oct 3, 2022 ... I am a Google Sheets/Excel novice. I have tried different variations of INDIRECT but can't get the formula to reference G2 (which for example ...
Can a cell value be used to reference a sheet name? - Google Docs ...
https://support.google.com/docs/thread/225164832/can-a-cell-value-be-used-to-reference-a-sheet-name?hl=en Jul 11, 2023 ... Can a cell value be used to reference a sheet name? I have sheet1 sheet2 and sheet3. if I have a cell B3 on sheet1 with a value of 2 is it ...
Referencing data from another sheet using a variable sheet name ...
https://support.google.com/docs/thread/4078098/referencing-data-from-another-sheet-using-a-variable-sheet-name?hl=en Apr 12, 2019 ... Using this formula to reference data from another sheet (sheet names are years)... =2018!M47. Is it possible to reference a cell address instead of hard coding ...
=INDIRECT() has a #REF! error even though formula is correct ...
https://support.google.com/docs/thread/12065995/indirect-has-a-ref-error-even-though-formula-is-correct?hl=en Aug 15, 2019 ... For example, I want to reference various cells in different sheets. The Sheet names can change so I have a page where you can type in the ...
Can you dynamically build the 'sheet name'!Cell Reference part of ...
https://support.google.com/docs/thread/40307606/can-you-dynamically-build-the-sheet-name-cell-reference-part-of-the-match-formula?hl=en Apr 16, 2020 ... I'm trying to get the match formulas in cell B25 on the 'Monthly View' tab to be dynamic as it pertains to the sheet name.
Give the sheet name to a cell automatically - Google Docs Editors ...
https://support.google.com/docs/thread/48798217/give-the-sheet-name-to-a-cell-automatically?hl=en May 23, 2020 ... In order to get the sheetname through the use of a formula, you need to use a script to create the custom formula.
Reference data from other sheets - Computer - Google Docs Editors ...
https://support.google.com/docs/answer/75943?hl=en&co=GENIE.Platform%3DDesktop Select a cell. Type = followed by the sheet name, an exclamation point, and the cell being copied. For example, =Sheet1!A1 ...
"Unresolved Sheet Name" Workaround when copying or renaming ...
https://support.google.com/docs/thread/25074318/unresolved-sheet-name-workaround-when-copying-or-renaming-tabs?hl=en Jan 8, 2020 ... Is there a way to force a re-calculation on all of those "Unresolved Sheet Name" cells without deleting and re-entering each formula one at a time?
Dynamic worksheet name in vlookup - Google Docs Editors ...
https://support.google.com/docs/thread/140832159/dynamic-worksheet-name-in-vlookup?hl=en Dec 16, 2021 ... Just referencing the cell creates an error. Details. Sheets,Mac OS,Business. Locked. Informational notification. This question is locked and ...
Indirect to a cell on a separate sheet with a space in its name ...
https://support.google.com/docs/thread/110097538/indirect-to-a-cell-on-a-separate-sheet-with-a-space-in-its-name?hl=en May 16, 2021 ... I am trying to enter an indirect formula on another sheet (Sheet46) that looks for cell E26 on those "Day" sheets, and returns that value.
How can I import multiple cells from one spreadsheet to another ...
https://support.google.com/docs/thread/173705377/how-can-i-import-multiple-cells-from-one-spreadsheet-to-another-spreadsheet?hl=en Aug 3, 2022 ... ... spreadsheet, and I followed the ImportRange and sheet name and cell number. ... references, like =A2 on a direct reference in the local sheet.
named variable references include sheet name - Google Docs ...
https://support.google.com/docs/thread/171412677/named-variable-references-include-sheet-name?hl=en Jul 16, 2022 ... Exclamation marks are also used to reference cells in other sheets in the same file. Google sheets, Excel and Openoffice all use all the same ...
Increment sheet name in formula - Google Docs Editors Community
https://support.google.com/docs/thread/145617230/increment-sheet-name-in-formula?hl=en Jan 13, 2022 ... or, you could refer to a cell on Row 1 to generate the number you need. =Indirect("PayPeriod" & Row(A1) & "!$A$13:$A$22").
Dynamic Formula Referencing Another Sheet - Google Docs Editors ...
https://support.google.com/docs/thread/201506996/dynamic-formula-referencing-another-sheet?hl=en Feb 11, 2023 ... For example enter the tabs name in a cell and all my formulas should use this cell for tab's name. For reference I used one such formula in A2 ...
How to Check and Compare Sheet names to an array- or list ...
https://support.google.com/docs/thread/97739530/how-to-check-and-compare-sheet-names-to-an-array-or-list?hl=en Feb 11, 2021 ... This formula will refresh automatically every time any cell in the spreadsheet is hand edited. uses indirect functions to dynamically change ...
Error "Unresolved sheet name" when copying tabs from one google ...
https://support.google.com/docs/thread/12478976/error-unresolved-sheet-name-when-copying-tabs-from-one-google-sheets-file-to-another?hl=en Aug 21, 2019 ... on the individual cell with the error message, the problem is resolved and the formula is then ok. But as I cannot do so for hundreds of cells ...
If a sheet name contains apostrophe, what's the proper syntax for an ...
https://support.google.com/docs/thread/6497633/if-a-sheet-name-contains-apostrophe-what-s-the-proper-syntax-for-an-off-sheet-cell-reference?hl=en May 20, 2019 ... I can see that Sheets uses the 'Moe"s'!A1 notation, but when I type that into a cell in X, it tells me "unresolved reference" to 'Moe"s'.