I have two workbooks with several sheets in each. I have a dropdown to select the sheet name that I'm using for reference for URLs and to reference other sheets in the main book.

I successfully used IMPORTRANGE to get data from the other workbook when I put the sheet name in it.

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/12Up9RK9bveEPN35iXq3V1QouJMgXELgzzoOdLnID5lU/edit?usp=sharing", "AMT!B2:M8")

AMT needs to be replaced with the value from another cell.

I've referenced cells in other sheets using INDIRECT

, but not sure how to do it in this case in this particular string.

I've tried doing it a number of different ways, and this is my most recent attempt

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/12Up9RK9bveEPN35iXq3V1QouJMgXELgzzoOdLnID5lU/edit?usp=sharing", "INDIRECT("'"&D4&"'!B2:M8")")
  • Welcome. Please remember that as per site guidelines when an answer addresses your question, accept it and even upvote it so others can benefit as well. Oct 13, 2020 at 18:38
  • @marikamitsos you might consider upvoting the question since it's apparently clear enough to answer :) The author can't upvote your answer unless they have 15 reputation.
    – Glorfindel
    Oct 13, 2020 at 19:26
  • @Glorfindel The "upvote" encouragement actually goes to every one who can. As you know upvoted answers attract more attention. On the other hand, you are right. The OP's question is well formed and does worth the upvote. Especially for a new comer. :) Oct 13, 2020 at 20:21

1 Answer 1


You do not need the INDIRECT function in your formula.

All you need to do is use


(where D4 holds AMT or is a cell using a Data Validation dropdown list)


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.