Vlookup glitchy

Post Reply
sodaspop
Posts: 4
Joined: Thu Jan 14, 2021 7:01 pm

Vlookup glitchy

Post by sodaspop »

Been using XLS files for years with MS Excel under Windows 98 and Windows 7. One file, "ledger," has several worksheets and Vlookup tables used by another file, "invoice." "Invoice" was usually opened and was able to access the tables OK without "Ledger" being opened (The link message to Ledger properly comes up when Invoice is opened).
New computer, Windows 10, Planmaker 2018: when "Invoice" is opened and accesses "Ledger," not opened, the Vlookup works fine as it had but only finds data in the first half of the Vlookup (row) range. The table in "Ledger" goes from A2:C400. The Vlookup works fine up to row 201, then any lookup in the table past that row returns zeroes. The workaround is to have "Ledger" opened in the background before "Invoice" is opened, and then "Invoice" successfully fetches data in rows past 201. Why would Vlookup bail after half of the table is accessed when the file with the tables is closed and work OK only after the file with the tables is opened first.
Lookup column is properly numbered in sequence, nothing unusual
SuperTech
SoftMaker Team
SoftMaker Team
Posts: 2930
Joined: Wed Mar 11, 2020 5:31 pm

Re: Vlookup glitchy

Post by SuperTech »

Thanks for reporting this problem. Please share the associated file of PlanMaker in which you are getting this problem so that we can do further investigation for resolution.

If you want to send it to us privately, please e-mail us at the forum[at]softmaker.de

Please also include the forum URL of this topic so that we can trace your e-mail.
viewtopic.php?f=300&t=20782&p=68770#p68770
SuperTech
SoftMaker Team
SoftMaker Team
Posts: 2930
Joined: Wed Mar 11, 2020 5:31 pm

Re: Vlookup glitchy

Post by SuperTech »

Thanks for sharing the files. I was able to reproduce the problem and forwarded the details to our development team for further investigation.
Post Reply

Return to “PlanMaker 2018 for Windows”