Hello, I found out that certain functions do not work with closed source files and one of them is offset which I am using in my formula: =OFFSET('[Master CPFR.xlsx]MOT VZN'!$B$1,MATCH($D$2,'[Master CPFR.xlsx]MOT VZN'!$B$1:$B$300,0),34). Please look at the formula and suggest what would work with a closed source file getting the same values and keeping the values.
Thanks
Ade
Bookmarks