<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 - Allow VLOOKUP function to work on the left specifying a negative index"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=123746">123746</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Allow VLOOKUP function to work on the left specifying a negative index
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>3.3.0 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>blackhole@lobianco.org
</td>
</tr></table>
<p>
<div>
<pre>Description:
The VLOOKUP() function works specifying a value to look-up in a column X and
the number of columns on the right where to retrieve the desired output on the
same raw of the founded value.
Often however I find myself to have the value to look-up on the right, and the
return value on the left.
My suggestion is to allow specifying a negative index of number of column and
this would have to be interpreted to lookup the value on the rightmost column
of the interval given and return the value on the specified column on the left.
Steps to Reproduce:
VLOOKUP(A1:D10,"car",2,0) (current implementation) returns the value in the B
column at the row where on column A the word "car" is found.
VLOOKUP(A1:D10,"car",-2,0) (proposed implementation) should return the value in
the C column at the row where on column D the word "car" is found.
Actual Results:
Negative index results in an error
Expected Results:
Negative index should mirror the request and look at the left of the rightmost
column.
Reproducible: Always
User Profile Reset: No
Additional Info:
I never use it, but the same thing could possibly apply also to HLOOKUP()</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>