Refer Entire Column of Another Worksheet by its number

Hi,

Please help me to solve below query...

Cell Value of A1 in Sheet 1 = 16. (it may be any integer number)
I want to derive value of last non empty cell of a particular column of Sheet2 in Cell A2 of Sheet 1. I have put formula in cell A2 as =LOOKUP(2,1/('Sheet2'!A:A<>""),'Sheet2'!A:A),which gives me value of last non empty cell in column A of Sheet2.

But I need value of column reference to be dynamic based on cell value of A1. Actually I want to derive column number to be result of formula : (A1*2)-1 i.e. Column Number 31 i.e. column AE of sheet2 should be referred in this formula automatically.

Is it possible to do this with any excel formulae?

=LOOKUP(2,1/(INDEX('Sheet2'!A:NN,0,(A1*2)-1)<>""),INDEX('Sheet2'!A:NN,0,(A1*2)-1))

That is exactly I was looking for...

Thanks a Lot Tim.. Its a great help to me and I mean it....