[Libreoffice-bugs] [Bug 122418] New: Issue with Vlookup function

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=122418

            Bug ID: 122418
           Summary: Issue with Vlookup function
           Product: LibreOffice
           Version: 6.1.3.2 release
          Hardware: Other
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: hijaas313 at gmail.com

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:

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190102/284e1331/attachment.html>