Lookup giving #value error

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

.
You can post your workbook for review.

Before doing that ... look at the quote symbols within the formula ... something doesn't look right but I could be wrong.

Hello everyone,

Here is the File. The Sheet name is called VO4 DRAFT in the Cell G12.

Br

Thanks thats it Bo_Ry!!

I cant believe I missed to put the indirect again in the end.

Thank you