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.
Just tried, and I see what you mean. Having selected text directly in
the cell, right-click doesn't do anything.
I hadn't noticed that before. Maybe it's a new change (I updated to
LibreOffice 6.1.2 on Linux Mint yesterday), or I just haven't noticed
since I generally use the keyboard shortcuts anyway.
A few other ways of copying the formula which still work:
- From the formula bar, just under the toolbar, you can select,
right-click and copy
- From directly in the cell, select and use the menu Edit > Copy, or
press Ctrl+C; these still work, even though you can't 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:-
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!!!
The formula you show seems to work for me, assuming your "second sheet"
is (somewhat confusingly) named "Sheet1". LibreOffice 6.1.2 on Linux
Mint, but I don't think the version of OS should make any difference in
I put the following data starting at A2 in Sheet1 (your "second sheet"):
Your formula in cell B2 of Sheet2 (corresponding to your unnamed "first
If I put one of the letters q, w, e, r, t, y, u, i, o, p in cell A2 of
that sheet, the formula in B2 shows the corresponding letter from column
B of Sheet1.
Perhaps I've misunderstood what you're trying to do, or maybe there's
something about the specific data you're using which causes this to
misbehave. There has to be an exact match between the value looked up
and the value in Sheet1 column A. Make sure there are no leading or
trailing spaces in any of the values, for example.
Quotes are only needed around the sheet name if there are spaces in the
To unsubscribe e-mail to: email@example.com
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Impressum (Legal Info)
: 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