I have 2 spreadsheets, Test1 and Test2. In Test2, Cell B2 I want to access a cell in test1. I want to use the value in cell A1 (the value is test1) indirectly to access cell A2 in test1. This is the formula I use and am getting a Formula Parse Error. I have also included links to the test spreadsheets:
=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1HLuD8Y4ApxXc2Zt3osHkTTsdWBjpiOIXFSFOdslca_Q/edit#gid=194909829","INDIRECT($A1&""!$A$2"")")
Test2:
https://docs.google.com/spreadsheets/d/10TA2hEwiDc9g-9_V30TQImZsgJVzVA2WFZifmbdL0d4/edit#gid=0