Yeh, actually, I figured that syntax out. It's the Defined range part
that's driving me nuts.
Thanks!
On 10.07.2006, at 16:01, Paul wrote:
The following worked for me :
=VLOOKUP(A2;'file:///H:/price.ods'#$Sheet1.A2:B8;2;0)
However this is not using a defined range. Can't seem to find the
syntax for a range... The help suggests that this should be able to be
done however.
/paul
On 7/11/06, Curtis Vaughan <[EMAIL PROTECTED]> wrote:
Can someone help me with the following syntax. Although maybe you
can't do this with VLOOKUP. I want to pull data from a different
spreadsheet.
So I have tried something like this:
=VLOOKUP(A3;"V1.ods";Vessels;1;0)
Where A3 is the reference in the sheet, V1.ods is the file in the
same directory, Vessels is defined as a Data Scope in V1.ods, 1 is
the column in Vessels to pull from compared to A3 and 0 is sorting.
I've tried various ways of writing this but can't seem to get the
syntax right. I'm pretty certain it has to do with the file name and
the data scope (as doing it within one worksheet is easy).
Thanks for any input.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
