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
