On 07/04/2009 02:57 PM, NoOp wrote: > On 07/04/2009 01:41 PM, Andy wrote: >> >> >> NoOp wrote: >>> >>> =VLOOKUP(B2,'file:///home/<myusernamefolder>/<folderwithbothfiles>/file1g.ods'#sheet1.$a$2:[.$I$25],8,0) >>> >> >> =VLOOKUP(SearchCriterion; Array; Index; SortOrder) is the form for the >> function. The overall form seems a little off. >> >> =VLOOKUP >> (B2;'file:///home/<myusernamefolder>/<folderwithbothfiles>/file1g.ods'#sheet1.$a$2:$I$25;8;0) >> >> Hope this helps. > > Ah, thanks. That's closer... > > This works: > > =VLOOKUP(B2,'file:///home/<myusernamefolder>/<folderwithbothfiles>/file1G.ods'#$Sheet1.$A$2:$I$25,8,0) > > This gives the #NAME error: > =VLOOKUP(B3,'file:///home/<myusernamefolder>/<folderwithbothfiles>/file1g.ods'#$sheet1.$a$2:$i$25,8,0) > > The filename is case sensitive (as it should be on linux), but the key > was getting rid of the brackets (as Joe noticed as well - thanks Joe). > Now that I've got the function working correctly I can see if I can > reproduce the user's problem. > > Thanks guys!
That did the trick. I am able to open the file from multiple user accounts on this machine & also across a Samba network link. Thanks again Andy & Joe! --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
