title: Google sheets: Arrayformula with importrange
body: <p>I'm trying to work with combined arrangeformula and importrange formulas. I want that from spreadsheet1:<a href="https://i.stack.imgur.com/AsG88.jpg" rel="nofollow noreferrer">Table1</a> P4 value would be taken to spreadsheet2 C3 cell: <a href="https://i.stack.imgur.com/fCvRd.jpg" rel="nofollow noreferrer">Table2</a> and only when i add new link to column &quot;L&quot; it will put automatic value at C4. So i want to use arrangeformula so it will work on whole column, but i want to fix that from all the links i add it would take same &quot;P4&quot; value. Possible?</p>