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


On 05/10/2018 15:53, Brian Barker wrote:
At 11:40 05/10/2018 +0100, Budge Noname wrote:
I have a value in a column (which is not the first column,) ...

What does it matter which column it is in? (Answer: it doesn't.)

... in the first sheet and second sheet with a two column table of values with their equivalents. I want to look up the value find the equivalent from the second sheet and enter it in the adjacent column. Cannot use VLOOKUP ...

Er, you probably can ...

... because the value is not in first column.

I'm not sure what you are thinking of when you say "first column" here!

What is best way forward please?

First, there is no restriction in all this for anything to be in the first column in the sense of column A of any sheet: your material can be anywhere. Secondly, the only restriction in the use of VLOOKUP() is that the column in which you are searching for a match should be to the left of the column containing the corresponding value you wish to harvest - and not even necessarily adjacent. In your case, that means that your two-column table on the second sheet needs to have its values on the left and the equivalents to the right - very probably what you would arrange naturally anyway.

If your (second sheet) table was part of the spreadsheet's printed output and you specifically wanted the columns in the other order (which is perhaps unlikely), you could always make a copy in the other order of columns somewhere out of your print range and use that for the VLOOKUP() search. By "copy", I mean a dynamic one using formulae, of course, not just a dump of the current values of the data.

I trust this helps.

Brian Barker


Hi Brian,
I am struggling here because I get an Err:502 but all looks OK with the VLOOKUP. BTW How on earth can I just copy and paste the formula so I can copy it here? It becomes highlighted in black and I cannot right click to copy.

Could my problem be that the values I am looking up are not unique but can be one of several values I am looking up in order to find the substitue?

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


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