Re: [libreoffice-users] [Calc] The LOOKUP() function (Calc vs. Excel)

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: users+unsubscribe@global.libreoffice.org
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