[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[libreoffice-users] What works in one file not in other help please.


I am trying to do a VLOOKUP to fill in data from one sheet into another.

This works between existing related files which are from previous
month's quarter but not for my new data for this quarter. Other than
actual entries the files are the same.

Is there a switch I have turned off perhaps. I recall trying to stop
something a while ago. This is the entry I am trying to make work:-

=VLOOKUP(B2,'file:///L:/Customer_Names_by_Ref/Sorted_Customer_8_Character_Names_in_Sage_by_SuperControl_&_LH_Ref_to_Jun_2019.ods'#$Sheet1.$A$2:$B$2039,2,0)

When I enter the same expression but with the more recent data file
(...to_Sep_2019.ods) I get #Ref for each entry.
Back with the dunces once more!!!
Budge


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.