I have problems doing a vlookup in an external sheet. Up to now I need to refer as: VLOOKUP(C15,'file:///C:/.....ods'#$pricelist.$B$10:$D$82,2,0)) and the price as: VLOOKUP(C15,'file:///C:/.....ods'#$pricelist.$B$10:$D$82,3,0)) I'd like to use a named range for this, something like: VLOOKUP(C15,'file:///C:/.....ods'#pricetable,2,0)) VLOOKUP(C15,'file:///C:/.....ods'#pricetable,3,0)) I would expect that this should be possible. Is there something I have missed? Is there any documentation about the scope and precise syntax of using a named range?
Created attachment 151208 [details] named range pointing to another spreadsheet i don't think, this is possible. but you can create a named range pointing to another sheets
Not possible - see bug 60170
But seems a dup of tdf#72594 *** This bug has been marked as a duplicate of bug 72594 ***
Now that it is explained, its clear for me how it works. The method of a named range created in the local file is okay for me. Issue may be closed (do not know how to do that). Thanks for helping and answering.