Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

The usual way to reference a sheet is here but how do you reference a sheet when the sheet's name is a value in a cell?

For example,

A1 = "Sheet number two"
B1 = A1&"!B4"

Here I want B1 to display the value in 'Sheet number two'!B4 but it's not working for me. Any ideas?

share|improve this question

1 Answer 1

up vote 8 down vote accepted

You need to use the indirect() function. So in cell B1 you will put the formula: =indirect(A1&"!B4")

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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