Quote Originally Posted by Colin Legg View Post
Welcome to the forum.

One choice would be:

=INDIRECT("'Sheet "&$A$1&"'!B2")
Thanks a lot for your help. And I figured out how to make it so you could drag the formula as well in case anyone else searches something like this.

I added a row at the top and typed in the column letter in each top cell. I then added a column to the right and typed in the row number in each cell of the column I needed.

Then I changed my formula to :

=INDIRECT("'Sheet "&$A$1&"'!"&B$1&""&$A2)

And I was able to drag it.

Anyway. Thanks a ton. Hopefully I can help someone along the way.