Welcome to the forum. One choice would be: =INDIRECT("'Sheet "&$A$1&"'!B2")
Hope that helps, Colin RAD Excel Blog
There are currently 1 users browsing this thread. (0 members and 1 guests)
Forum Rules
Bookmarks