Alex Cuevas
Reputation: 13
Using a cell's value in a function to fetch data from a different sheet - google sheets
I have two google sheets: sheet1 and sheet2. In sheet1 I have in cell A1 this the text "sheet2!b2". How do I reference A1 in cell A2 to be able to pull the ACTUAL data from sheet2!b2? When I try to use in a formula, i just get the sheet2!b2 text... it does not pull the value from sheet2. Any help would be appreciated. Thank you
Upvotes: 1
Views: 64
Answers (1)
nabais
Reputation: 2037
As @RemcoE33 said in your comment, you can use the Indirect formula, it takes a string in the formula, so you can reference it as:
Indirect(A1)(as seen in the image below, orIndirect("Sheet2!B2")
(the value of my sheet2!b2 is Hello, so you can see it works. For more information you have the documentation of Indirect
Upvotes: 1
Related Questions
- How to pull data from another sheet in a user defined VBA function
- In Google sheets use Value from a Cell ( retrieved with =MATCH ) to get Information from another sheet
- Get values from other sheet using VBA
- Referencing a cell from another worksheet in a function for VBA
- How to use a value from a cell in a function in VBA?
- How to make a function use the data that is on the sheet, the function is written on?
- Excel, use value returned from function to select the corresponding cell
- Unsure of how to use cell data to get data from another worksheet
- How do I use the result of one function in another function to get the value stored in a cell in another sheet in Excel?
- excel function to get value of another cell