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


On 04/10/2018 10:24, Budge wrote:
I cannot sort out my vlookup when looking up in another sheet and entering in first sheet. I was hoping to ask for help but now I can't even highlight my entry and right click to copy and paste here.  As soon as I highlight line it goes black and will not right click.

Also I cannot get single quote to work even though as you advised a while ago I have Tools Autocorrect Options > Localized Options turned off
Am I losing my grip?

I shall type in what I have now:-

=VLOOKUP(A2,$Sheet1.$A$2:$B$1276,2,0)

I am seeking to find the value in A2 in first sheet from an array in "sheet1" (the second sheet) column A and enter the result in the entry column in the first sheet.  I think there should be single quotes around Sheet1 which is the label of sheet 2 but I cannot get them to save!!!

Grateful for any help when you have time please.

---
This email has been checked for viruses by AVG.
https://www.avg.com


I think I have solved my automatic quotes repeat but still have the VLOOKUP question please.

--
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

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.