Skip to main content
removed google-drive
Link
Jacob Jan
  • 23.3k
  • 16
  • 106
  • 195
Tweeted twitter.com/#!/StackWebApps/status/177085223224356865
Source Link
E.Beach
  • 263
  • 1
  • 2
  • 5

Refer to Sheet with value in Cell?

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?