From 615a5f87d3f7137b8584d085f9693e8c92dcf296 Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Sun, 25 Apr 2021 16:47:55 -0300 Subject: tdf#141822 Rename parameter for standard compliance VLOOKUP, HLOOKUP, LOOKUP and MATCH Change-Id: I348024294f24a5190f0d5054dab2f83355d08567 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/114632 Tested-by: Jenkins Reviewed-by: Olivier Hallot --- source/text/scalc/01/04060109.xhp | 18 +++++++++--------- 1 file changed, 9 insertions(+), 9 deletions(-) diff --git a/source/text/scalc/01/04060109.xhp b/source/text/scalc/01/04060109.xhp index ec48f0faf3..c8aedc337b 100644 --- a/source/text/scalc/01/04060109.xhp +++ b/source/text/scalc/01/04060109.xhp @@ -273,18 +273,18 @@

VLOOKUP

- 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 Sorted 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 Sorted 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. +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 Sorted 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 Lookup is not found, the last value that is smaller than the criterion will be returned. If Sorted 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. - =VLOOKUP(SearchCriterion; Array; Index [; SortedRangeLookup]) + =VLOOKUP(Lookup; Array; Index [; SortedRangeLookup]) - SearchCriterion is the value searched for in the first column of the array. + Lookup is the value of any type looked for in the first column of the array. Array is the reference, which is to comprise at least as many columns as the number passed in Index argument. Index is the number of the column in the array that contains the value to be returned. The first column has the number 1. - SortedRangeLookup is an optional parameter that indicates whether the first column in the array contains range boundaries instead of plain values. In this mode, the lookup returns the value in the row with first column having value equal to or less than SearchCriterion. E.g., it could contain dates when some tax value had been changed, and so the values represent starting dates of a period when a specific tax value was effective. Thus, searching for a date that is absent in the first array column, but falls between some existing boundary dates, would give the lower of them, allowing to find out the data being effective to the searched date. Enter the Boolean value FALSE or zero if the first column is not a range boundary list. When this parameter is TRUE or not given, the first column in the array must be sorted in ascending order. Sorted columns can be searched much faster and the function always returns a value, even if the search value was not matched exactly, if it is greater than the lowest value of the sorted list. In unsorted lists, the search value must be matched exactly. Otherwise the function will return #N/A with message: Error: Value Not Available. + SortedRangeLookup is an optional parameter that indicates whether the first column in the array contains range boundaries instead of plain values. In this mode, the lookup returns the value in the row with first column having value equal to or less than Lookup. E.g., it could contain dates when some tax value had been changed, and so the values represent starting dates of a period when a specific tax value was effective. Thus, searching for a date that is absent in the first array column, but falls between some existing boundary dates, would give the lower of them, allowing to find out the data being effective to the searched date. Enter the Boolean value FALSE or zero if the first column is not a range boundary list. When this parameter is TRUE or not given, the first column in the array must be sorted in ascending order. Sorted columns can be searched much faster and the function always returns a value, even if the search value was not matched exactly, if it is greater than the lowest value of the sorted list. In unsorted lists, the search value must be matched exactly. Otherwise the function will return #N/A with message: Error: Value Not Available. You want to enter the number of a dish on the menu in cell A1, and the name of the dish is to appear as text in the neighboring cell (B1) immediately. The Number to Name assignment is contained in the D1:E100 array. D1 contains 100, E1 contains the name Vegetable Soup, and so forth, for 100 menu items. The numbers in column D are sorted in ascending order; thus, the optional Sorted parameter is not necessary. @@ -333,9 +333,9 @@

MATCH

Returns the relative position of an item in an array that matches a specified value. The function returns the position of the value found in the lookup_array as a number. - MATCH(SearchCriterion; LookupArray [; Type]) + MATCH(Search; LookupArray [; Type]) - SearchCriterion is the value which is to be searched for in the single-row or single-column array. + Search is the value which is to be searched for in the single-row or single-column array. LookupArray is the reference searched. A lookup array can be a single row or column, or part of a single row or column. @@ -395,9 +395,9 @@ If LOOKUP cannot find the search criterion, it matches the largest value in the search vector that is less than or equal to the search criterion. - LOOKUP(SearchCriterion; SearchVector [; ResultVector]) + LOOKUP(Lookup; SearchVector [; ResultVector]) - SearchCriterion is the value to be searched for; entered either directly or as a reference. + Lookup is the value of any type to be looked for; entered either directly or as a reference. SearchVector is the single-row or single-column area to be searched. @@ -457,7 +457,7 @@ Searches for a value and reference to the cells below the selected area. This function verifies if the first row of an array contains a certain value. The function returns then the value in a row of the array, named in the Index, in the same column. - HLOOKUP(SearchCriterion; Array; Index [; SortedRangeLookup]) + HLOOKUP(Lookup; Array; Index [; SortedRangeLookup]) For an explanation on the parameters, see: VLOOKUP (columns and rows are exchanged) -- cgit