Date: prev next · Thread: first prev next last
2017 Archives by date, by thread · List index


Struggling here with VLOOKUP which I hope is the right tool.

I have a column of numbers on one sheet (sheet 1) and on another sheet (sheet 2) a column of numbers with an associated name in adjacent cell. My objective is to find the name associated with the number on sheet 2 and enter it in sheet 1, or put another way: to take (in turn down the column) the number on sheet 1, find this number in the column in sheet 2 and write the name adjacent to that number in cell adjacent to the number I started with in sheet 1.

The numbers are random and not necessarily to be found in second sheet. If no name is found I need some marker entered so I know I must
recourse to a manual search elsewhere.

I think VLOOKUP might be the right tool but got stuck right at the start trying to reference across two sheets. I have both open in same instance of LibreOffice.

Please could somebody confirm my approach and or advise how to proceed.
Budge

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Context


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.