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")
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!
Recent Answers
- Joshua Engel on Why fry rice before boiling?
- Jon Church on Why fry rice before boiling?
- Peter Machado on Why fry rice before boiling?
- Lex on Does Google Analytics track 404 page responses as valid page views?
- haakon.io on Why fry rice before boiling?
Recent Questions
- How can I transform graph image into a tikzpicture LaTeX code?
- How Do I Get The Ifruit App Off Of Gta 5 / Grand Theft Auto 5
- Iv’e designed a space elevator using a series of lasers. do you know anybody i could submit the designs too that could manufacture the concept and put it to use
- Need help finding a book. Female OP protagonist, magic
- Why is the WWF pending games (“Your turn”) area replaced w/ a column of “Bonus & Reward”gift boxes?