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? (Not VBA)
Bookmarks