Using a lookup function to find the last value in a column based on a value in an array where the function is written, I have used the following function:

'=LOOKUP(2,1/($A3&"!F:F">0),$A3&"!F:F")

A3 is the vertically anchored cell I am using that references the sheet name where I want to execute the lookup while column F stores the values that I want the function to return. The result I am receiving is, #VALUE! The question is, is there a better way to execute this procedure without drawing the error. I have attached an example file. Thanks in advance.

Lookup Value.xlsx


- Ben