https://bugs.freedesktop.org/show_bug.cgi?id=51349
--- Comment #7 from mariosv <mari...@miguelangel.mobi> ---
Have you looked for the function in the help:
"
Syntax
=VLOOKUP(SearchCriterion; Array; Index; SortOrder)
---------
Vertical search with reference to adjacent cells to the right. This function
checks if a specific value is contained in the first column of an array. The
function then returns the value in the same row of the column named by Index.
If the SortOrder parameter is omitted or set to TRUE or one, it is assumed that
the data is sorted in ascending order. In this case, if the exact
SearchCriterion is not found, the last value that is smaller than the criterion
will be returned. If SortOrder is set to FALSE or zero, an exact match must be
found, otherwise the error Error: Value Not Available will be the result. Thus
with a value of zero the data does not need to be sorted in ascending order.
"
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
