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:
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.) I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
Created attachment 148225 [details] vlookup Test added test file
(In reply to hijaas313 from comment #0) > 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 vlookup formula has a 4th parameter you have to use, if the first columns is not sorted: https://help.libreoffice.org/6.1/en-US/text/scalc/01/04060109.html?System=WIN&DbPAR=CALC#bm_id3152809 Enter the Boolean value FALSE() or zero if the first column is not sorted in ascending order, e.g. =VLOOKUP($G$2;$A$3:$D$12;2;0)