CODEWITHSUNDEEP
google-sheets
Andre Arancibia
Andre Arancibia

Reputation: 177

Referencing a cell into a formula

This question pertains to Google Sheets. In column F of one "List" tab of my sheet, I have the name of all the other tabs in my sheet. All the other tabs contain information specific to one single topic. Im trying to get all of column N in "List" to pull up cell G2 of each sheet. So far, ive been using this:

='(sheet name)'!G2 ;in the N column, changing (sheet name) manually and individually

But I'd rather have the content of the F fill the (sheet name) part of the formula. Any way to do so?

Upvotes: 0

Views: 68

Answers (1)

Gary's Student
Gary's Student

Reputation: 96753

With sheet names in column F, in N1 enter:

=INDIRECT("'" & F1 & "'!G2")

and copy down. Please note the single quotes in the formula.

enter image description here

This should work for both Excel and Google Sheets.

Upvotes: 1

Related Questions