1

I am trying to have a sheet like this:

April | A2 of Sheet named April

March | A2 of Sheet named March

etc.

I want to be able to just paste data in these monthly sheets and simply drag the whole row in the main sheet down and it should populate the data fields from the correct sheet.

Is this possible in Google Spreadsheets? Is INDIRECT the correct function for this?

What I tried:

=INDIRECT('A2'!B2)

This should give me B2 cell content of the sheet named as whatever is displayed in the current sheet's A2 cell, but it doesn't, I get an error instead.

Relevant Links, which failed to help me:

migrated from superuser.com Aug 8 '16 at 18:02

This question came from our site for computer enthusiasts and power users.

2

I found the answer:

=INDIRECT(A9&"!B2")

A9 = Cell, which contains the name of the sheet you need to referrence B2 = Cell with data in sheet you need to referrence

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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