About 1,866,711 results (2,624 milliseconds)
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 ... The sheet is going to have hundreds of worksheets with different names, so I want the formula to reference the unique worksheet name from row 2.
Reference cell data from another Google spreadsheet (not a ...
https://support.google.com/docs/thread/8274394/reference-cell-data-from-another-google-spreadsheet-not-a-different-tabbed-sheet?hl=en Jun 18, 2019 ... Replace the <Sheet URL or Key> with your source sheet URL and replace AirlineCosts!A1 with the correct tab name and cell but in both cases ...
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( ...
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 ...
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 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 ... Depending on the data, I will need to use a difference Sheet with a different name. I have the query formula occurring more than once to ...
How to rename a TAB based on a cell value? - Google Docs Editors ...
https://support.google.com/docs/thread/5236560/how-to-rename-a-tab-based-on-a-cell-value?hl=en May 1, 2019 ... I want to give the tab name automatically with the content in the cell ... cell elsewhere, no script is trigger when the reference cell is ...
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 ... I want to be able to change the value of the worksheet name 'xxx ... Just referencing the cell creates an error. Details. Sheets,Mac OS ...
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 ...
Function to Combine Data in Multiple Cells on one Sheet to a Single ...
https://support.google.com/docs/thread/12617867/function-to-combine-data-in-multiple-cells-on-one-sheet-to-a-single-cell-on-another-sheet?hl=en Aug 23, 2019 ... The formula will read the value in column A and use it to reference the tab name. The values in the header row are converted to real dates so ...
SHEETS: How to reference the Text/Value from one cell within a ...
https://support.google.com/docs/thread/137041108/sheets-how-to-reference-the-text-value-from-one-cell-within-a-formula-of-another-cell?hl=en Nov 24, 2021 ... Within that row is a number of formulas referencing a SHEET with that corresponding name. ... name value within all 21 formulas that reference it.
Indirect formula doesn't work when it precedes referenced tab ...
https://support.google.com/docs/thread/85903560/indirect-formula-doesn-t-work-when-it-precedes-referenced-tab-creation?hl=en Nov 29, 2020 ... the formula is correct and when editing the cell contents and ... tab names and paste them back to the original cells/values. The ...
How can I set sheet name ! to a cell value in a function? - Google ...
https://support.google.com/docs/thread/154394429/how-can-i-set-sheet-name-to-a-cell-value-in-a-function?hl=en Mar 10, 2022 ... I have a google sheets that has the tab names to the left and a funtion to the right to load in the data. =VLOOKUP("serch for this",'TAB NAME'!A1:B8,2,FALSE)
Reference data from other sheets - Computer - Google Docs Editors ...
https://support.google.com/docs/answer/75943?hl=en&co=GENIE.Platform%3DDesktop Open or create a sheet. Select a cell. Type = followed by the sheet name, an exclamation point, and the cell being copied. For example, =Sheet1!A1 or ...
Lookup Matching Value Across Multiple Worksheets And Return ...
https://support.google.com/docs/thread/43383714/lookup-matching-value-across-multiple-worksheets-and-return-sheet-name?hl=en Apr 29, 2020 ... I pasted that formula on cell L2 and dragged down the column. For some reason, it works well for ONE of the worksheet names - the one at the ...
Copy row based on cell value - Google Docs Editors Community
https://support.google.com/docs/thread/188331775/copy-row-based-on-cell-value?hl=en Nov 12, 2022 ... When you reference a tab name (sheet name) that's more than one word long, single quotes are needed around the name. I suspect the syntax ...
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.
Having problems with a simple INDIRECT statement - Google Docs ...
https://support.google.com/docs/thread/17935898/having-problems-with-a-simple-indirect-statement?hl=en Oct 28, 2019 ... G5"), where cell B33 is the name of the tab. Cell 33 = October 2019. returns: Function INDIRECT parameter 1 value is 'October 2019 !G5'. It ...
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.
Lookup value across multiple sheets and return sheet name ...
https://support.google.com/docs/thread/293291880/lookup-value-across-multiple-sheets-and-return-sheet-name?hl=en Aug 28, 2024 ... I would need a formula that given a value searches for that value in all sheets and returns in a cell only the name of the sheet in which that value is present.