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! --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
