Hi all
I encounter an issue with a specific excel file - I cannot use vlookup function (returns error) when the table array is on another sheet in the same workbook.
This happens for the same excel file both in my business and my personal laptops.
I tested the function in a new excel file in both laptops and works fine.
Does anyone have any idea about the source of this problem in the specific excel file?
Unfortunately I cannot share the file as it contains confidential data. But I attach an example which is working to show the formula I am using: VLOOKUP(A5,Sheet2!$F$9:$H$19,3,FALSE)
Any idea/advice will be much appreciated!
Bookmarks