-
Best way to use lookup to find last value in column of another sheet
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules