TransWikia.com

How to use a sheet name that is referenced in a cell in a formula?

Super User Asked on November 7, 2021

Column B is a list of my sheet names created using Index. I simply want the formula in column C to go to a certain cell on whatever sheet name is listed in column B. I’m struggling with what I think is very simple? I have a formula that works, but it doesn’t allow me to change the name of the sheet. I thought it would be something like ='B4'!$P$33

My formula thus far.

2 Answers

Say we wanted:

=Sheet1!Z100

but wanted to put the sheetname in a separate cell. Use:

=INDIRECT("'" & B4 & "'!Z100")

Please note the single quotes!

enter image description here

Answered by Gary's Student on November 7, 2021

Use the INDIRECT function to return the reference specified by a string.

You just concatenate your string and wrap it with the function.

=INDIRECT(B4&"!$P$33")

Answered by FlexYourData on November 7, 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