Ted
Reputation: 21
Reference cell to another sheet cell which has array formula?
I tried to use indirect but it does not work as follow:
=ArrayFormula(indirect(Frmla!B1))
Sheet name: Frml, cell B1 has the array formula phrase.
Also tried to index the whole array formula but I got an error too
=index(Frmla!B1)
Sheet URL:
https://docs.google.com/spreadsheets/d/1SOsZX-Vrowxc3XlcaeH_7o3FYYFSJY3Wcsagkj5F2Eo/edit?usp=sharing
Upvotes: 1
Views: 540
Answers (1)
Related Questions
- Refer to itself in ARRAYFORMULA
- Array formula to reference cell on another tab, displaying plain text instead of formula
- Construct a Query to Reference Indirect Array
- Using INDIRECT in Array Formula
- Alternative to INDIRECT in ARRAYFORMULA to reference the cell above
- Reference a cell using formula?
- referencing an array that's stored in a cell within a formula
- How to make a relative reference in an array formula in Google Sheets
- How do I reference one cell created in ARRAYFORMULA from another?
- how to reference a formula from another cell in google sheets