Refer to dynamic column letter

[strooman]

I have Sheet 1 and Sheet 2.
On Sheet1 I have a reference to cell =Sheet2!N$36, but I want to refer to the column letter (N) in a dynamic way. As you can see I placed the column letters on Sheet1.
How to adjust the formula and refer to "N"? Something like =Sheet2!&(INDIRECT(Sheet1!A2))&$36

Book1
	A	B	C
1	column_Letter	Stage	Sheet2
2	N	stage1	46
3	U	stage2	54
4	AB	stage3	0
5	AI	stage4	0
Sheet1

Cell Formulas
Range	Formula
C2	C2	=Sheet2!N$36
C3	C3	=Sheet2!U$36
C4	C4	=Sheet2!AB$36
C5	C5	=Sheet2!AI$36

 

[Fluff]

How about

=indirect("Sheet2!"&A2&"36")

 

[strooman]

Sometimes it's so simple. Thanks Fluff, works like a charm.

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Alex Blakenburg]

Just curious in Sheet 2 do those columns not have a heading that says Stage1, Stage2 etc ?