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