TransWikia.com

How to create draggable sheet reference with the same cell?

Web Applications Asked on November 18, 2021

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?

One Answer

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")

Answered by user0 on November 18, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP