<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Enhancement to Calc functions MATCH, HLOOKUP and VLOOKUP"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=107371">107371</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Enhancement to Calc functions MATCH, HLOOKUP and VLOOKUP
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.2.3.3 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>enhancement
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>david_lynch@blueyonder.co.uk
</td>
</tr></table>
<p>
<div>
<pre>MATCH(SearchCriterion; LookupArray; Type)
SearchCriterion 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.
Type may take the values 1, 0, or -1. If Type = 1 or if this optional
parameter is omitted, it is assumed that the first column of the search array
is sorted in ascending order. If Type = -1 it is assumed that the column is
sorted in descending order. This corresponds to the same function in Microsoft
Excel.
If Type = 0, only exact matches are found. If the search criterion is
found more than once, the function returns the index of the first matching
value. Only if Type = 0
Enhancement requested:
*** or Type > 1 ***
can you search for regular expressions (if enabled in calculation options) or
wildcards (if enabled in calculation options).
If Type = 1 or the third parameter is omitted, the index of the last
value that is smaller than or equal to the search criterion is returned. This
applies even when the search array is not sorted. For Type = -1, the index of
the first value that is larger than or equal is returned.
Enhancement requested:
*** If Type > 1, only exact matches are found. If the search criterion is found
more than once, the function returns the index of the Type'th matching value.
VLOOKUP(SearchCriterion; Array; Index; Sorted)
HLOOKUP(SearchCriterion; Array; Index; Sorted)
Enhancement requested:
*** Sorted does the same as the Type parameter in function MATCH. ***
This enhancement is compatible with existing MATCH, HLOOKUP and VLOOKUP.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>