2

I'm not very familiar with Google Sheets and have a question that may be very simple but I can't seem to find an answer.

I am trying to pull information from one same cell example, H47 from multiple sheets. If I type '1'!H47, is there a way for this sequence to follow? When I highlight the '1'!H47 and drag, it keeps the sheet number and changes the cell.

How can I set it up for the sheet to change but not the cell?

0

1 Answer 1

0

You will need to use INDIRECT where you will freeze H47 with quotes and make 1 "movable" like:

=INDIRECT(ROW(A1)&"!H47")

enter image description here


If you need to drag it to the right use:

=INDIRECT(COLUMN(A1)&"!H47")

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