<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 - EDITING: Vlookup doesn't work"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=108268">108268</a>
          </td>
        </tr>

        <tr>
          <th>Summary</th>
          <td>EDITING: Vlookup doesn't work
          </td>
        </tr>

        <tr>
          <th>Product</th>
          <td>LibreOffice
          </td>
        </tr>

        <tr>
          <th>Version</th>
          <td>5.1.6.2 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>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>qfsuarezo@yahoo.es
          </td>
        </tr></table>
      <p>
        <div>
        <pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=133748" name="attach_133748" title="The file whit the problem.">attachment 133748</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=133748&action=edit" title="The file whit the problem.">[details]</a></span>
The file whit the problem.

Hello, I have a problem whit Vlookup, in the file you will see the sheet3 in
the column B and C I have a formula for look the value in Column a. Column B
looks in sheet2 in the same file and it doesn't works. Column C looks in a file
xlsx and it works, whit errors.

This is a very useful function, and if we can't trust it, then we have a very
huge problem.

I send the files, and I can see that is the same problem whit the <a class="bz_bug_link 
          bz_status_RESOLVED  bz_closed"
   title="RESOLVED INVALID - Vlookup doesn't work at all"
   href="show_bug.cgi?id=53277">bug 53277</a>,
but pleas do not dismiss it as RESOLVED INVALID</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>