<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 - Issue with Vlookup function"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=122418">122418</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Issue with Vlookup function
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.1.3.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>Other
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</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>hijaas313@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
I have entered few names along with specific data and tried to call back in
another part in the same sheet using vlookup but it worked with certain records
but haven't given any results for some. I couldn't find out the reason or
pattern for the issue
Steps to Reproduce:
1. created a data array
2. using vlookup I have tried to retrieve respective data into another cell
3. Not worked in the first attempt but after I have pressed F9 it worked for
some records.
4. I tried the same procedure for other records it shown nothing.
Actual Results:
Sometimes, for some records shown the correct results and not for other's.
Expected Results:
When I enter the name of a person, which is defined in data array table it
should retrieve the batch no (some number), item (Product), Price.
Reproducible: Couldn't Reproduce
User Profile Reset: No
Additional Info:</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>