Hello, I have an issue that I am not able to solve.
The problem is I got a formula with a Lookup but I get all the time a #Value no matter what I try.
The formula is this:
=LOOKUP(2,1/("'"&A27&"'!I:I<>"""),"'"&A27&"'!I:I")
My formula comes from this one : =LOOKUP(2,1/(A:A<>""),A:A)
Where I ry to get the last value in a column.
The "'"&A27&"'! is a dropdown-list created by the sheet names that exists. I:I<>"" should find the value of the last non-empty cell in the column.
But its not working. do you guys have a solution to it?
Thanks in advance
Bookmarks