... so this is an Excel problem because it behaves differently with
respect to its own help...?!!!
In any case this "Excel bug" yields some documents with some
uncompleted/uncorrected formulas that don't generate errors in the
corresponding cells... with the concrete risk that this become "a
standard" behavior and/or some additional work in migrating to LO, for
example.
Isn't it?
Carlo
ing. Carlo Strata
-
via Botticelli 1/4
30031 Dolo - VE
Italia - Italy
-
tel. +39.041.822.0665
cell. +39.347.85.69.824
Skype carlo.strata
Google carlo.strata.69
-
[email protected]
PEC: [email protected]
Il 30/11/2014 17:49, Luuk ha scritto:
On 30-11-2014 12:16, Carlo Strata wrote:
Hi Everyone,
Brian understood exactly what I meant. I.e.:
=LOOKUP(;A5)
Have a nice sunday,
Carlo
according to Microsoft, this firt value is 'REQUIRED'
VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])
lookup_value (*required*)
The value you want to lookup. The value you want to look up must be in
the first column of the range of cells you specify in table-array .
For example, if table-array spans cells B2:D7, then your lookup_value
must be in column B. See the graphic below. Lookup_value can be a
value or a reference to a cell.
or, in the Vector form:
LOOKUP(lookup_value, lookup_vector, [result_vector])
The LOOKUP function vector form syntax has the following arguments:
lookup_value *Required*. A value that LOOKUP searches for in
the first vector. Lookup_value can be a number, text, a logical value,
or a name or reference that refers to a value.
see: http://goo.gl/SqmmS9
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
